I have a model I reverse engineered from a Microsoft Access 2010 database. However, several relationships did not import or get set up properly. When I manually create a relationship between two tables, I am unable to edit the foreign keys. Basically, nothing appears in the Foreign Keys list box and I am unable to manually add a new relationship. I am using the latest version 4.2.6. I am guessing it is locking the relationships because the table does no have primary keys, which is not my concern as I really just need to represent the relationship that should be there.
On the flipside, the table I am joining to has 3 primary keys. When I try to set up a non-identifying relationsihp, it forces all three keys into the target table. I understand why it does this, but I only needed (wanted) two of the keys to map to the target table, and cannot remove the third relationship in the Foreign Keys tab.
Understand, I did not design the db, I mainly wanted to establish the relationships between the tables for documentation purposes because the orignal designer did not handle this. Is there any flexibility with editing Foreign Keys or can this be a feature request to “override” the current locked-in business rules of TDM?
Thank you for your help,