AnsweredAssumed Answered

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

Question asked by happyho on Oct 30, 2013
Latest reply on Oct 31, 2013 by philmodjunk

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?

      

      

      

      

Outcomes