Let me start by saying that I'm an MS Access developer trying to get up to speed on FileMaker. While I find FileMaker "interesting" some relatively simple tasks that would take me 5 minutes in Access seem almost impossible in FileMaker.
Case in point: I have a table with a dozen or so fields in each record and 300,000+ records in the table. I also have a layout that lists the records in the table. Obviously no one is going to scroll through that much data so I want to frontend the list with a very simple form that allows the user to enter values for several of the fields (all indexed) to select a subset of the records, which will be displayed in the list layout. Most of the search fields will be drop-down boxes so the user can quickly enter his/her criteria. This will be an iPhone app, so I'm NOT interested in using the built-in Find options on the standard menu - I want to initiate the search manually once the criteria has been entered. Any suggestions?