5 Replies Latest reply on Jun 9, 2014 5:52 PM by BruceRobertson

    Filtering Database Results NOT Using Portals

    liquidcipher

      Hi,

       

      I'm new to creating databases and layouts in Filemaker and I'm having some problems coming up with a working filter script for my layout pages. I'm trying to filter my records by my [state] field so that I will only see records for specific states on specific layouts. I've managed to get my scripts to arrange the database alphabetically, which I then realized I could just use the sort function, but I can't get it to exclude all the other states from say my New Hampshire screen. Any and all help will be much appreciated as I've searched and searched and can only find info on filtering inside of portals.

       

      Thanks!

       

      Filemaker Pro Advanced 13 / Filemaker Server 12