File Marker 10 Advanced : Help with Sorting Field Contents
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.
Big thanks in advance for any input that you may have!
FileMaker 10 [Advanced]