Which relationship diagram in split database? 1

[StuMunro]

I have split my database into 2 as recommended else where in this forum. 1 for tables (backend) and the other for queries forms and code.

Do I have to maintain the relationship diagrams in both databases when I change joins/cascades between tables etc?

Or can I just maintain the one in the Form database with the linked tables?

Stu.

 

[scking]

You only maintain relationships in the database containing the tables. Normally, that would be in the server database containing the data for those designs which have split databases.

Steve King Professional growth follows a healthy professional curiosity