Yeah, you can send the DB to firstname.lastname@example.org
alternativly, send me the actual names of your tables and i'll create the query using the names you have.
the problem you are having is that the value that are stored in the field are the ID numbers, you see the other information because access tries to present it in a 'human friendly' format. In your query you need BOTH tables and you filter on the actual field from the lookup table.
Let me know how it goes...
Dave - MAD
nil illegitimi carborundum
Semper in excreta, sumus solum profundum variat