Lookup Tables in Query

[newmanje]

I am trying to write a query in a database for my sister. The table I am trying to query refers to a lookup table for two fields. I need to be able to specify data for one of these fields but every time I try it fails to return any records.

They are both text fields and one of them is the primary key. If I specify the data for the primary key it returns records but not with the other field.

I've not worked with lookups before. Can anyone help?

 

[BNPMike]

Can you post the SQL for the query?

 

[newmanje]

What I need to stipulate is the Vendor but it only returns detail when I stipulate a brand as well.


SELECT returns.[Store #], returns.[Customer Name], returns.[Repair #], returns.[Date out], returns.Brand, returns.Vendor, returns.Qty, returns.[Style #], returns.Colour, returns.[PLU#], returns.[Date recv'd back]
FROM returns
WHERE (((returns.Vendor)="luxottica") AND ((returns.[Date recv'd back]) Is Null));