Hi,
I have an 'Events' Database in which I'm trying to record time spent by various staff members at each event.
tables; tblAppDetails, tblEmployee, tblHours
I have already made a good start on the main input form, but need some help of the employee/hours sub-form.
It's a relationship question I suppose, but what I'm trying to do is select an employee from a drop down list, then record the date they attended the event, start time, end time, breaks? and total time. The total time would have to be calculated so how would I go about that? Would I be able to use the Datediff function here?
Main problem is the relationships between the tables;
Each Event can be attended by many staff,
Each staff member can attend on multiple days
I'm so bad at relationships, any pointers on tables, primary fields etc would be very helpful!
Thanks for any help!
FrankyG
I have an 'Events' Database in which I'm trying to record time spent by various staff members at each event.
tables; tblAppDetails, tblEmployee, tblHours
I have already made a good start on the main input form, but need some help of the employee/hours sub-form.
It's a relationship question I suppose, but what I'm trying to do is select an employee from a drop down list, then record the date they attended the event, start time, end time, breaks? and total time. The total time would have to be calculated so how would I go about that? Would I be able to use the Datediff function here?
Main problem is the relationships between the tables;
Each Event can be attended by many staff,
Each staff member can attend on multiple days
I'm so bad at relationships, any pointers on tables, primary fields etc would be very helpful!
Thanks for any help!
FrankyG