How are Relationships used at Runtime

[wilsonaa]

Hi,
I would appreciate if someone could let me know how Access uses table relationships during runtime. I created my table relationships which where helpful during query creation and for documenting the application. If I then delete all the relationships from the relationship screen (keeping the query relationships intact as part of the existing queries) it doesn't seem to make a button of difference.

Thanks AWilson

 

[jrbarnett]

Relationships are used during runtime to enforce rules, such as having a master record before detail records are added, or whether to permit updates in the master table and whether to cascade them through to the details etc.

John

 

[Draig]

"Deleting" the tables from the Relationships screen does NOT delete the relationships. You should first delete the relationship LINES, then delete the TABLES to permanently remope them.


Barborne
Worcester
UK