Can anyone explain what the benefit of the different join types are when joining fields/tables in the relationships view in MS Access (I'm using 2010 but I guess this applies to earlier versions)? I can perfectly well understand why I might want a left outer join or an inner join when performing a query but I don't grasp what this does when I'm editing the relationships between tables themselves (i.e. not in a query). Clearly, 'enforce referential integrity' means I can't accidentally create orphan records (and query joins won't do this) but the applicability of join types outside queries mystifies me.
feedback
|
|
On the relationship view, please think of it as this is how the database was designed to operate. When you create queries, those joins will automatically appear based on the relationship view. The database will work without any relationships in the relationship view but for every query and report you create; you will have to create the appropriate joins. | |||
|
feedback
|
|
Depending on the design of the database where a join really only applies under certain condition. Anything you define in the relationship view for the most part will be used always. If you need a join for only a single query then may want to only create that join as part of the query. | |||
|
feedback
|
