Creating Relationships in Queries

[thegrimmerdiscovery]

Morning



Put this down to my huge lack of experience with Access but could anyone give me a quick answer as to why you'd create relationships when designing a query? Shouldn't these relationships already be described in the database design...if you see what I mean??

Thanks

[isladogs]

When a query is created, tables (and queries) can be joined in different ways (inner/left/right joins) whether or not a relationship has been defined at table level.

The main purpose of creating relationships between tables is to enforce referential integrity.
See http://www.mendipdatasystems.co.uk/r...ps1/4594533224

[thegrimmerdiscovery]

Many thanks for that Colin - I'll be keeping the hand-out close by for the foreseeable.

[isladogs]

You're welcome. See related link to different query types on the same page