G Guest Nov 10, 2004 #1 I am confusing myself...are the joins in "Relationships" going to be the same joins in a query?
R Roger Carlson Nov 10, 2004 #2 When you create a relationship in the Relationship Window AND if you turn the AutoJoin property on, then when you add the two tables to the Query Builder, it will automatically join them based on the relationship. Is that what you meant? -- --Roger Carlson Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
When you create a relationship in the Relationship Window AND if you turn the AutoJoin property on, then when you add the two tables to the Query Builder, it will automatically join them based on the relationship. Is that what you meant? -- --Roger Carlson Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L