Need help with a validation formula
I have two databases: The first contains records of "Events", and contains fields with workers scheduled to work at each event. Each worker is in a separate field (Worker1, Worker2, Worker3, etc.).
The second database contains records of dates in which specific workers are unavailable. To give a quick example: If 25 workers are unavailable on June 1st, there would be 25 different records in this database with the 25 different names in one field, and the June 1st date in another field in all 25 records.
Is there a validation formula I could use in the "Events" database which would prevent workers from being entered into those fields if they have that Event's date listed as them being unavailable?