Multiple Searchable values in single database field

[theflakker]

I created a simple database and am using the built in search tool to display records. One field is the "Type" field set to char-255. If I put in the value 'regular' then it shows up in my search table as 'regular' in the drop down list. If I put in 'regular, holiday' then it shows up as a single drop down item called 'regular, holiday'. I want it to show up as two separate items in the drop down list 'regular' and 'holiday'. What I want is to have a single record show up under different search requests for field "Type".

[lwyau]

The dropdown list in the search form is constructed by collecting all distinct values in that field from the entire table. It is an exact match situation and does not do partial matches as you described.

[theflakker]

Thanks, I guess I figured as much. So how does one do what I want to do - have single records show up under different search values for a single field?