Query criteria on lookup field

[eyalpel]

Hi All
need your help please.
I need to run Query with criteria (simple text finding) on one of the values in the table.
but the data type of this field is a lookup type and i can not find a way to do it.
I try the regular option with Like "TEXT" but it is not working on this type of field.

any ideas ?

Thanks
Eyal

 

[Minty]

Lookup fields are not fun to work with, as they hide the fact that you are actually storing the primary key. http://access.mvps.org/access/lookupfields.htm will explain some of the issues.

My advice is to remove the lookup field from your table and use a simple proper relationship to the second table, however your criteria probably should be the primary key not the text value.

 

[eyalpel]

Thanks
I am really not an expert in Access, i create my simple DB but i am still very green.

the field i like to search for, needs to be a multiple value field, the available values i am taking from another table, and i thought that the only way is to define the field type as "lookup" field with multiple values option.

i succeeded to work with it, but the results from the query brings me double results of the table.

 

[Minty]

Mutli-valued fields are also something I avoid like the plague I'm afraid. Have a read here https://www.access-programmers.co.uk/forums/showthread.php?t=234481