Is it necessary to create table relationships BEFORE creating a query?

[accessmatt]

Is it necessary to create table relationships before creating a query that draws on data from multiple tables and/or is there some way to create a query that draws on multiple tables without creating table relationships?



Thanks!

[alansidman]

I hardly ever create table relationships. I create my queries and join tables as necessary in the query.

[accessmatt]

I hardly ever create table relationships. I create my queries and join tables as necessary in the query.

Thanks Alan! Can you provide a quick overview on creating join tables in the query?

[alansidman]

http://www.techonthenet.com/access/queries/joins1.php

To join tables, drag the PK in the first table to your FK in the second table.

Look at the link above to see how to change the joins.