AnsweredAssumed Answered

Calculated value list?

Question asked by sk on Feb 3, 2010
Latest reply on Feb 4, 2010 by sk


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.