User-Based Finds, With Drop Down Menus to set find parameters
Looking for help developing a solution that enables users to perform searches through our table to find records that match what they are looking for specifically.
What I am looking to do is create a layout page where guests at my restaurant can select wines based on certain criterias that match what they are looking for based on price, body, style, color, etc.
Ideally, this page would be somewhat in the form of a survey.
Ideally it would look like this
Would you prefer red or white? (Drop Down Red or White)
What price range would you like your wine to be in (Drop down, price parameters)
Do you like lighter bodied or heavier wines (Drop Down, Light Medium Heavy)
I have tagged all the wines in the table with these specfic criteria in different fields.
So how can I have them make these different selections, and then perform a find based on what they select, and display their results as a list so that they can pick and choose from there...
Philmodjunk if you are reading this, your help has been so valued to us in this work, we really do appreciate all of your efforts and thank you for your constant support