Live Form Lookup

[anonymust]

How do I create a special table (that when I enter data via a form) it looks up id the word/entry in the table and displays it to me




For eg,
I have a table with these records

• chicken
• chicken legs
• chicken breast
• chicken wings
• frozen chicken

But when Im enter the word "chicken" in my form i want to see a list of all these items what contain the word "chicken"


Sort of like a live search feature within my forms..


Im trying go create a database with food items in my neighbourhood.

[June7]

Don't create a special table, build a query.

A dynamic parameterized query is one method. Review http://www.datapigtechnologies.com/f...tomfilter.html