Adding a second employee to an event

[rickzman]

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!

 

[Steve]

Hello Rick,

TblEvent should have a primary key of EventID. Remove EmployeeID from
TblEvent. Create a new table named TblEventEmployee that looks like:
TblEventEmployee
EventEmployeeID
EventID
EmployeeID

You then need a form/subform for data entry. The main form will be based on
TblEvent and the subform will be based on TblEventEmployee. Make the subform
a continuous form. Set the LinkMaster and LinkChild properties to EventID.
Now you will be able to enter events in the hain form and enter a list of
employees that support the event in the subform.

Steve
(e-mail address removed)

 

[KARL DEWEY]

Create a tblEventEmployees like you did for tblEventDetails with equipment.