Hi,
I have this problem and if I don't figure out how to do it, the database I'm creating is very much pointless.
I have 3 tables: tblEmployees, tblServices and because this is many to many relationship I created 3rd table tblAllocations (only two fields: EmployeeID, ServiceID but I'm using combo boxes).
In tblServices I have StartDate and Duration fields.
What I need is to assign employee (it can be one, two, three or even 20) to a service when adding a new record. One employee can be assigned to many services GIVEN that the time frame doesn't clash.
What should I use? What is the simplest way to do it?
Thanks to everyone interested,
Matt
I have this problem and if I don't figure out how to do it, the database I'm creating is very much pointless.
I have 3 tables: tblEmployees, tblServices and because this is many to many relationship I created 3rd table tblAllocations (only two fields: EmployeeID, ServiceID but I'm using combo boxes).
In tblServices I have StartDate and Duration fields.
What I need is to assign employee (it can be one, two, three or even 20) to a service when adding a new record. One employee can be assigned to many services GIVEN that the time frame doesn't clash.
What should I use? What is the simplest way to do it?
Thanks to everyone interested,
Matt
