3 Replies Latest reply on Oct 31, 2013 7:08 AM by philmodjunk

    How can I choose different value from 2 drop-downlist that reference to the same table?

    happyho

      Title

      How can I choose different value from 2 drop-downlist that reference to the same table?

      Post

           Dear All,

           I have some  2 tables Staff(staff_id, name) and Task(task_id, staff_id, approval_id). The relationships from Staff to Task are two relationships: staff:staff_id -Task:staff_id and Staff:staff_id - Tasj:Approval_id. Because one staff can be assigned to on the task and another staff can be approval to the task. 

           But when I create to 2 drop-down list for assignee and  approval to get Staff name from Table Staff. It always show the same value whenever I chose item in one of them. How can I choose a different staff in 2 dropdown list?