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 using class table inheritance. Each of my records under my subclass's table has an Id that corresponds with an Id on the superclass's table, as it should. But no foreign key is defined. When I manually add the key myself, LightSpeed tries to add them as a one-to-many relation between the subclass and superclass. Why does LightSpeed not define this key, and can an option be included to support it? I don't trust myself to remember to always deselect that certain relation when updating my model from the database. I'm using the latest nightly build. |
|
|
|
|
Thanks for raising this - this does indeed sound sensible so I will add this to our enhancement backlog. As to why it does this - I dont have an exact answer but this will most likely stem from the way in which we look for relationships when the designer inspects the database schema - where an FK exists we expect an association between two entities rather than an inheritance relationship.
|
|
|
|
