AnsweredAssumed Answered

File Marker 10 Advanced : Help with Sorting Field Contents

Question asked by chawks1995 on Nov 10, 2009
Latest reply on Nov 11, 2009 by ninja

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

 

Outcomes