Hi guys. I am a bit stuck with this one and could use your suggestions.
I have a scheduling app which is used to assign workers to a project on a specific date.
The below is a simplified version of my tables and columns:
In the scheduling app I have a form view with the following fields:
- ref to select worker_id from worker table
- ref to select project_id from project table
I want to filter the worker_id’s to display only the workers who have not already been assigned to a project on that date. I.e filter schedule records to match the selected date of the current record being entered, then match those worker_id’s to the worker_id’s in the worker tables then display only those which do not have matches.
Thanks for your help!