Hi all
Long time since i asked a question here, been busy with other stuff, however, here I am back with Access.
Im currently working for a client who offers training on their software.
The have a stock of laptops (12 in total say)
Three Course Trainers
Courses which last between 1 and 2 days
What they need is a way to book courses which:
A: Won't allow the trainer to overlap - Can only present one course at a time
B: Wont allow any more that 12 laptops being used at any one time although this could be over two or possibly three courses
C: No more than 3 courses per date
I need a way to book the laptops and reduce the number of laptops available for subsequent booking on those already booked dates.
I have a table for:
Resources
Booked Resources
Trainers
Courses
any ideas would be very helpful, code would be ideal too.
Long time since i asked a question here, been busy with other stuff, however, here I am back with Access.
Im currently working for a client who offers training on their software.
The have a stock of laptops (12 in total say)
Three Course Trainers
Courses which last between 1 and 2 days
What they need is a way to book courses which:
A: Won't allow the trainer to overlap - Can only present one course at a time
B: Wont allow any more that 12 laptops being used at any one time although this could be over two or possibly three courses
C: No more than 3 courses per date
I need a way to book the laptops and reduce the number of laptops available for subsequent booking on those already booked dates.
I have a table for:
Resources
Booked Resources
Trainers
Courses
any ideas would be very helpful, code would be ideal too.