2 Replies Latest reply on Feb 4, 2010 12:46 PM by sk

    Calculated value list?



      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.