Are their any advantages, optimization or otherwise, to defining the relationships between queries, queries and subqueries, queries and tables, etc in the Access Relationships window?
Well, I tried at least.
Windows 10 
Access 2016
Are their any advantages, optimization or otherwise, to defining the relationships between queries, queries and subqueries, queries and tables, etc in the Access Relationships window?
VIP
Windows 10 Access 2010 32bit
not really, relationships are about defining rules around the data, not optimisation of queries.
VIP
Windows 10 Access 2010 32bit
Agree with Ajax.
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.
Defining SQL parameter for Access Query
Posting Permissions
Reply With Quote