Pop-up menu portal filtering and multiple related records
I am using File Maker Pro Advanced 12 on Windows 7.
I have a database containing a series of Accounts to which are assigned Contracts. Each Account can have multiple Contracts, and each Contract can have multiple Order #s.
The DB is set up as follows:
Accounts::ID = Contracts::fk_Account_ID
Orders::fk_Contract_ID = Contracts::ID
I have a portal on the Accounts layout that allows me to create contracts related to that account. What I can't get to work, however, is displaying a second portal that could be filtered via a pop-up menu to display orders related to a specific contract. In other words, I would like to select one of the contracts related to that account and display all related orders, as well as add and remove those related orders.
Is this possible? Is there a better way to do this?
Thanks for your time.