query question

[David M. Fizer]

Hello


I have a query asking the user to type in the flavor of a product. My
problem is that some brands call their product either plain, traditional,
or meatless (all meaning plain). Is there a way if a user types in one of
the three that all records that have one of these three flavors show?


TIA,
David

 

[Douglas J. Steele]

I think the only way would be if you created a table of synonyms. Lookup
what the user types in, and use all of the synonyms in your query.