Lookup Table

[wycats]

I have three tables:

Requests: Stores data about maintenance requests
Categories: List of maintenance categories (i.e. mold, plumbing, etc.)
AssignedTo: List of people who maintenance requests can be assigned to

Each request has a category, and each person in AssignedTo has a
category.
The requests table contains a field for AssignedTo.

I'm trying to set up a lookup so that once a category is selected in
the Requests table, only AssignedTo's with the same category as the
category of the request itself will show up on the list. I tried to do
some queries, but I can't figure out a way to reference the current
record in a query.

Any thoughts?

 

[SusanV]

Are you using a form? If so reference it as Me.Control where Control = the
name of the dropdown box for Requests. Truthfully, the best way is to use
cascading comboboxes:
http://www.fontstuff.com/access/acctut10.htm