4 Replies Latest reply on Nov 11, 2009 8:21 AM by ninja

    File Marker 10 Advanced : Help with Sorting Field Contents

    chawks1995

      Title

      File Marker 10 Advanced : Help with Sorting Field Contents

      Post

      Hello All,

       

      I've been working on an order form and need help in setting up my order form's line-items. I've been following the FileMaker sample database for the "Banzai Gardens" but would like to have the following functionality when users are entering products on an order line-item:

       

      - The first field on the line-item is "Manufacturer" which is a field from the "Products" table.

        > When the user selects the Manufacturer form a pop-up menu based on a list the next field "Model" is pre-sorted to only contain products available from the selected manufacturer.

       

      I can't seem to figure out how to do this - Ugggg. I've attached a link to an image that illustrates the database setup and form view.

       

      Schema: files.me.com/chawks/zgm2mi

       

      Big thanks in advance for any input that you may have!

       

      chawks1995

      FileMaker 10 [Advanced]

      Mac OSX