This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
In my model I have Organizations and Persons A person has an OrganizationId because an organization can have multiple persons. The organization has PersonNLId and PersonInternationalId because an organization has one acting officer for the netherlands and international affairs. How can I model this in a way that i wont get a circular reference?
|
|
|
Are the Netherlands and International acting officers the only Persons associated with the Organisation, or is there also an open-ended People collection? |
|
|
NL and international acting officers are referenced from Organization to Person
Database: table Organization -- Id -- IntOfficerId (references Person.Id) -- NLOfficerId (references Person.Id)
table Person -- Id -- OrganizationId (references Organization.Id)
|
|