0

How do I show only records for staff not already working on a specific date?

I have a Page where I want to show any staff not scheduled to work one of our events on a specific date. We have multiple events on a single date. 
- User selects a date
- View would then show any staff member currently not scheduled for that day

Tables
- Event Details - event date, and all other details for an event
- Staff - staff information
-event_staff_join - event details(n:1), staff(n:1)

Looking for the code to populate the view. 

Reply

null