Foreign key sync

[themitch]

Hi

I'm surprised to find that when I associate a table with a Primary Key, with another table I have to manually create the foreign key/primary key association (using right mouse click on the relationship, then Foreign Keys, and selecting the two columns to connect)? And then once the association has been made, if I change the primary key (say the name, or the data type length, or something), the change isn't automatically reflected in the associated foreign keys.

Isn't this bread and butter stuff for a modelling tool? Or have I missed a setting somewhere?

Thanks for your help.

Martin

[Takeshi K]

Hi,

AFAIK, EA does not support what you want. We offer add-in 'DBMode' to support database modeling.

DBMode supports your first item, i.e. automatic generation FK and relationship between Tables by reffering PK from another Table. About the second item, DBMode does not update related items automatically[ch12288]either. But its checking feature can find type mismatching between PK and FK. Or, using Domain feature, changes will be automatically applied to both Tables.

DBMode:
http://www.dbmode.com/

Hope this helps,