Probably the dumbest question I'll ever ask but I need to know. Once i have a relationship established between two tables, what can i do?
What is the advantage to joining two tables?
Probably the dumbest question I'll ever ask but I need to know. Once i have a relationship established between two tables, what can i do?
What is the advantage to joining two tables?
1. Can set Enforce Referential Integrity and Cascade Delete and Cascade Update - let you do research on those features
2. When you build a query with multiple tables, the query designer will automatically set JOIN links - usually that is appreciated but sometimes links need to be different and have to manually change.
A db can be designed without any Relationships set.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.