Split database and relationships

[Gavx]

When the database is split between front end and back end where do you create the relationships? In the front or back end?

 

[theDBguy]

Hi. Relationships have to be created where the tables are defined. Normally, that means the back end.

 

[Gavx]

thanks

 

[zeroaccess]

You will also notice that if you design a single-file database and then later split it, the relationships will move to the back-end with the tables.

 

[The_Doc_Man]

True for ORACLE too.

 

[Gavx]

Thanks