Specifying a foreign key in the criteria (MISMATCH ERROR)

[stevoreeno]

I am getting a "type mismatch" error when I try to run this query that is pulling info from a lookup table. Access help told me it was a problem, but not how to fix it. It told me I should use them (foreign keys) when you specify criteria for a field. How do I do this?

 

[rac2]

Can you post the SQL for the query?

Type mismatch means that the datatypes of two expressions don't match and cannot be automatically converted to matching types. For example, the column values are integers and your query contains a criterion value that cannot be converted to an integer such as the letter A.

 

[stevoreeno]

The column that it is looking up is a lookup table of 4 names, first and last. I am getting this error even without anything in the criteria field???