I have built an Operations Log database. In the database I have built built
the following tables.
tblLab(Lab where testing will occur)
tblCustomer(customer who will test)
tblEquipment(each piece of equipment we operate)
tblEvent(particulars of event, i.e. startdate, starttime, enddate, endtime,
purpose, employeeID)
tblEventDetails(set up like an order, where the customer "orders" each piece
of equipmnet for the event)
tblEmployees(all possible employees from my group)

Relationships have been laid out and the database is functioning properly if
I only use one employee per event.

Queries have been built and calculations for TotalHrs have been injected
into the query in order to keep track of hours for the month. Caculations
work.

My question is how do I show another employee for those events where it
takes 2 employees to support the event? Then how would I calculate the times
in order to show that both employees had hours to charge against the
event(i.e 8 hour event which took 2 employees each charging time to the event
for a total of 16 man hours charged to the customer)?

I hope that I explained it so you can understand, I am in need of help!