Query Help

[Beth]

I have put together 2 tables. One for realtors (fields
are: realtor ID, Realtor first name & realtor Last name)
and one for property,( Fields: address, city, bedrooms,
realtor id, etc). I want to do a query for each realtor
to associate only their properties in table 2 to their
name from table 1. How can I do this. Each time I try it
just shows all the properties again just as I have entered
it.

Thank

Beth

 

[Cheryl Fischer]

Try this, Beth ...

1. In the Design View of a new query, add each table.

2. If you have already established a Relationship between your Realtor
table and Properties table, there should be a connecting line between the
RealtorID field in both tables. If there is no connecting line, put the
mouse pointer over the RealtorID field in the Realtor table. Hold down the
left mouse button and drag the mouse pointer until it is over the RealtorID
field in the Properties table. Release the mouse button, and you should see
that the RealtorID fields in both tables are now "joined"

3. Add the fields you want to see in your query's result into columns in
the grid. Be sure to include the RealtorID from the Realtor table in the
grid.

4. Now, in the Criteria: row of the column containing RealtorID, enter the
following:

[Enter Realtor ID:]

This is a parameter which, when you run your query, will allow you to enter
the RealtorID to search for. The query should return only information
related to that RealtorID. You can re-use this query for any RealtorID.

hth,