AnsweredAssumed Answered

Calculated value list?

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

Title

Calculated value list?

Post

Hi,

 

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. 

Outcomes