Relating Company & Employee fields
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!