Kayleigh
Member
- Local time
- Today, 22:14
- Joined
- Sep 24, 2020
- Messages
- 706
Hi,
I have three tables - tblStaff (staff info), tblStaffPosition (list of staff positions) and jtblStaffRoles (assigns each staff member 1+ positions). Currently several staff members have been assigned position/s.
How do I write a query to insert records in jtblStaffRoles to add 'unassigned' to all staff members not currently assigned a role?
Really appreciate your help!
I have three tables - tblStaff (staff info), tblStaffPosition (list of staff positions) and jtblStaffRoles (assigns each staff member 1+ positions). Currently several staff members have been assigned position/s.
How do I write a query to insert records in jtblStaffRoles to add 'unassigned' to all staff members not currently assigned a role?
Really appreciate your help!