create lookup table

[aftershokk]

I would like to create a table, which contains keywords that may be contained in a SKU description field.

Example:

Product 1 - Description - A tool by magic that will enhance your business.

I would like to create a query that would perform a lookup based on a table that will look for any of the keywords specified in the table.

The table may have one field that may contain the record business and a record for magic

I would like the query to use the contents of the table to perform a partial match and return the results

make any sense

 

[WayneRyan]

aftershokk,

It sounds like what you need is a multi-select listbox
that is based on your table of keywords. Use the search
facility here.

Wayne