I will try and explain what I have found out. Just do not know how to solve it.
I have an items table and in that table I have a field named BRAND, COLOR, DEALER.

When I put that field in that table I created a lookup wizard to get the data from the tables created BRAND, COLOR, DEALER to the items table with drop down box.

If I run the search query with bringing that data in it works fine.

However if I want to use my search criteria in those fields it will not bring up data.

I have changed the data type from numeric to short text and it does not change the fact that no data is brought over. So basic question what do I do?

These are some of the fields I need to use the criteria in to solve what I want to do.