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 am sure I have seen this topic discussed somewhere, but I can't find it again. I have a case where I have a many-to-many relationship between two entities. As a simple example, lets say one entity is Awards and the other is People. A People (pardon the grammar) may have many Awards, and likewise, an Award may be given to many People. However, in this case, there is meta-data describing the specific relationship that needs to be stored in the intersection table in the ERD. For example, I may want to store the DateAwarded, so that I know when each People was Awarded. What is the best way to construct this relationship in the designer, such that I will easily be able to modify/enumerate the data later on in the application? |
|
|
|
|
Just make the through entity explicit. You can then add columns to it and otherwise freely customise it just like any other entity. Here's some more info: http://www.mindscapehq.com/documentation/lightspeed/Working-with-Models-in-the-Visual-Designer/ManytoMany-Associations |
|
|
|
