Getting Multiple Information from two tables

[Guest]

I have two tables with information. Table 1 and Table 2
I want to display records from both tables based on zip and state for table
1 and
state from table 2. table 1 will have one unique record while table 2
could have several.

How do I set this up to search both tables and give me the requested
information?

 

[Amy Blankenship]

The first thing you want to do is establish the relationship between the two
tables in the relationships window. Presumably, this just involves dragging
the State field from table 1 to table 1. Keep in mind, though, that 1 to
many relationships typically have a parent-child relationship, so the record
on the one side would be less specific (state) and the record on the many
side (zip code). In your case, the data structure you've implied would
return all records in table 2 regardless of whether they reside in the zip
code in table 1 or not.

Regardless, once you have the relationship set up, you'll then go into the
query window and select New Query in Design Mode. Show Table 1 and Table
two. If you're not seeing the same relationship you set up before, drag the
field across again to make sure it is in place. Now, select the fields you
want to see in your query and drag them to the grid below. Run the query.

HTH;

Amy