AnsweredAssumed Answered

How do I create simple search form

Question asked by bajadude on Feb 11, 2016
Latest reply on Jun 18, 2016 by ykoutroulis

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?

Outcomes