Hi,

I will try to explain this the best way i can.

I have a grid which points to a table that just containes id codes.

tbl_my_codes
1001
1002
3004

The codes come from another table

tbl_my_names
1001 Food- Jam
1002 Food- Butter
3004 Equipment- Mixer

I have created a grid based on tbl_my_codes.

I want to add a textbox field in the search part of the grid and be able to search for the word 'food'. The result should be

1001
1002

How can i achieve this? Can it even be done?

Thanks in advance.

Denis