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
|
I'm trying to model something that would describe people and relationships. I created an entity called Person, then added a self-referenced through association to Person, with the auto through entity set to Relationship and the target collection name set to RelatedPeople Now, obviously doesn't work, because when trying to update database, LightSpeed complained "Column names in each table must be unique. Column name 'PersonId' in table 'Relationship' is specified more than once". So, what would be the recommended way to model this scenario? |
|
|
|
|
I _think_ I've found the answer to my question above from one of the earlier posting... Is there a plan to make self-referenced many-to-many relationship doable from the designer soon? |
|
|
|
