How can I choose different value from 2 drop-downlist that reference to the same table?
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?