If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding a second employee to an event
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! |
#3
|
|||
|
|||
Adding a second employee to an event
Create a tblEventEmployees like you did for tblEventDetails with equipment.
-- Build a little, test a little. "rickzman" wrote: 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! |
Thread Tools | |
Display Modes | |
|
|