Re: Limiting number of assignments in a many-to-many relationship
Re: Limiting number of assignments in a many-to-many relationship
- Subject: Re: Limiting number of assignments in a many-to-many relationship
- From: Art Isbell <email@hidden>
- Date: Mon, 12 Jan 2004 11:26:04 -1000
On Jan 12, 2004, at 10:49 AM, Steve Sharman wrote:
- There are many persons
- There are many organisations
- Many persons can be assigned to an organisation
- A person can be assigned to one and only one organisation
The way that I thought of approaching this was to implement a
many-to-many relationship in the usual way between person and
organisation, but implement a restriction at the Java level that would
ensure that a given person was assigned to only one organisation at a
time.
Your description is that of a to-many relationship from Organization
to Person and a to-one relationship from Person to Organization:
Person <<-> Organization
A many-to-many relationship seems inappropriate.
Aloha,
Art
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.