Where to define relationships?

[Dmitry Perets]

Hello,

My Access application consists of two MDB files: the application file and the database file. The application file has links to tables from the database file.
Now, I want to define relationships to optimize my database performance. Where should I define them? In the database file? In the application file? Both?

Thank you!

 

[Dennisk]

relationships must be set up in the back end (where the tables are) then when you link your tables a snapshot of the relationships is loaded into the front end with limited functionality. i.e. you couldn't specify cascade delete for instance.

 

[Dmitry Perets]

relationships must be set up in the back end (where the tables are) then when you link your tables a snapshot of the relationships is loaded into the front end with limited functionality. i.e. you couldn't specify cascade delete for instance.

Hm... And what happens when I define them in the front end? Do I get the cascade delete then?

 

[KeithG]

You can not actually create and save a relationship on a linked table. If you define a realtionship on a linked table, close the db, then reopen it the relationship will be gone. You must define the relationship in the back end.