Retrieve Records Using a Drop Down or Pop Up Menu?
I've been having some troubles with what seems to be a simple task. Forgive me if the solution is clear as glass.
I've been using drop down menus for data entry, which is wonderful, but I want to be able to use a drop down for record retrieval. For example, I have a brands table and an orders table which includes a season field and an order type field. I want to have controls on my layout so my users can select the Brand and/or Season and/or Order Type. Filemaker should then give me a list of all orders corresponding to those drop down entries.
Essentially, how the heck do I get Filemaker to know that my drop down box is a find selector, and not a data input? Thanks!