Calculated value list?
How would write a script to do this?
I have an employee table and a customer table. We have 5 different offices and each employee is assigned to one office (an attribute in the employee table). In the customer table, one selects from a drop down list, the sales office. There are 5 choices, CGY, CTR, EDM, VAN and TOR. I want the next field "Sales Rep" to be only showing the employees that are part of the selected office. Right now it shows all employees, a very long list.
I need to apply the same technique in the Orders table, and assign the correct employee to Sales Rep, Project Manager and Order Entry.
Thank you in advance for your help.