3 Replies Latest reply on Oct 30, 2014 11:17 AM by newbieo

    How can I create a pop-out menu that is conditional upon the selection of a different pop-out menu?

    newbieo

      Hello,

       

      I am new to FileMaker Pro and have just purchased FMP13 to use in our company. I am designing a system where it can link all of our clients, inventory, and production tickets that are issued. When I issue a production ticket, I would like all of my fields to only display the inventory available for the company that is selected. For example, if I create a new production ticket and select company A, the only labels I am able to select are related to company A, not all the labels in our inventory. I would also like to be able to deduct the number of labels entered from the production ticket from the Units on Hand in our inventory. I have tried using conditional value lists with no success and even tried using a logical function in the calculation field.

       

      Here is a screenshot of my relationships. The occurence table presently exists because I was dabbling with conditional value lists.

       

       

      Please help.

      Thanks.