A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Adding a second employee to an event



 
 
Thread Tools Display Modes
  #1  
Old March 8th, 2010, 03:58 PM posted to microsoft.public.access.tablesdbdesign
rickzman
external usenet poster
 
Posts: 1
Default 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!
  #2  
Old March 8th, 2010, 04:49 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Adding a second employee to an event

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



"rickzman" wrote in message
...
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  
Old March 8th, 2010, 04:52 PM posted to microsoft.public.access.tablesdbdesign
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:09 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.