1 Reply Latest reply on Jun 12, 2012 10:23 AM by TSGal

    record select

    JillX

      Title

      record select

      Post

      I have a Order table, with certain models. Models are with status like "open" and "closed". I may order one model several times. So one model may show "open" in one record and "closed" in others.

      Now I want to filter for new models, which they have never been selected under closed status. 

      How can I filter this?

       

      Thank you!

        • 1. Re: record select
          TSGal

          JillX:

          Thank you for your post.

          In FileMaker Go, tap the bottom right icon (horizontal lines with a magnifying glass).  Tap the last option "Enter Find Mode".  Then, go to the Status field and enter "Open" and tap "Go".  This will then find all record that have a Status set to "Open".

          To show all records again, tap the same lower right icon and tap the first option "Show All Records".

          Let me know if you need additional clarification.

          TSGal
          FileMaker, Inc.