Hi,
I have a DB of around 33 staff members.
They can all book Holidays for any week within the year, One Employee for example might book off on holiday the 1,2,3,4 January, a while later another employee might want the the same days.
That it is fine as we allow 2 off at the same time.
My thinking is that this situation is now a Many to many relationship but I'm not sure of how to structure it?
One employee may have one to many holidays, An Holiday may have one or many staff in the same holiday dates, months.
I know this requires a Junction table but what items/fields do I move into it to make this work in a form later (If a query feeds it)
I want to get this right before we move further.
Any help would be appreciated.
Attachment 27782