1 Reply Latest reply on Nov 10, 2014 11:19 AM by philmodjunk

    Relating Company



      Relating Company & Employee fields


      Hello Everyone,

      I'm a new user to Filemaker with what I'm hoping is a simple issue to answer. I'm using Filemaker 13

      I'm working on an order form to be used internally at the company. I've made fields which include both company name(clients) and "ordered by" (employees at those companies) and want to have them connected dependent on the company name selected. For example, company names include Apple, Verizon and T-mobile. Employees are Sarah & Mark(Apple), John(Verizon) and Mary(T-mobile). When Apple is selected I only want to have Sarah & Mark show up as options under "ordered by".

      I'm thinking that I need to set up calculations to reach my goal. If so, any suggestions to which I could use? Thanks!