Adding a second employee to an event
in [Tables]
|
Prev: Keeping data private per User in a multi user database
Next: Access Services?? Accessing DB from web??
From: rickzman on 8 Mar 2010 09:58 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!
From: Steve on 8 Mar 2010 10:49 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 santus(a)penn.com "rickzman" <rickzman(a)discussions.microsoft.com> wrote in message news:8BC3B5B1-1D95-431F-A4C9-586077B12483(a)microsoft.com... >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!
From: KARL DEWEY on 8 Mar 2010 10:52
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! |