AnsweredAssumed Answered

Relating Company

Question asked by ACardinale on Nov 10, 2014
Latest reply on Nov 10, 2014 by philmodjunk


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!