Hi,

Could somebody help me ?

My database has a Category field: values 1..50 (not necessary single values)
e.g.
field 1 - 1
field 2 - 1, 5
field 3 - 2, 30, 41
etc.

I would like to create pull down menu using description, e.g.:

Animals;
Electronics, telecomm;
Furniture, wood;
Machines and parts;

Each of description corresponds to numerical value, e.g.:

1 - Electronics, telecomm
2 - Furniture, wood
3 - Machines and parts

Now, I would like to search my databases selecting e.g. "Electronics, telecomm" from the pull down menu.

Results should show those fields where "1" is matched so:
field 1, field 2 but not field 3

and appropriate Category should be displayed:
"Electronics, telecomm"
not " Electronics, telecomm" and " Furniture, wood"

Does it make sense ?