QUOTE (Peter46 @ Mar 11 2012, 11:01 AM)
You use both of these because they are not the same.
Relationships define rules for how records are stored and maintained in tables. So you should use these to ensure integrity of your data.
In queries you create JOINS not relationships. Joins are used to extract and display related data. They do not affect how data is stored in the database. If you add tables to the query design grid, then Access ASSUMES that the join should be based on the same fields as the relationship set up in the relationships window. But this is not always true and sometimes the join has to be deleted and then set up in the required way for the query.
MS confuse the process by including an option for Join Type in the relationships screen. This should be ignored, in my view.
You only specify Join type in queries. Join types are critical in terms of how queries behave and so you have to consider the join type for every join in a query irrespective of any relationships you set up.
Thank you for your new concept that I learn