I currently have a table database that consists of Item Number, Item Name, Price. On Front-end, I created a form where the the user enters the Item Number, and the Item name & Price and populated with simple Lookup field, and then enter a quantity enter a Quantity field.
How can I give users the option to Search for the Item name instead...just in case the Item Number is damaged/illegible?