Form-Subform help

[KD]

I have a form with the following fields
ProdNum
ProdDate
Shift
Employees
Hours
MachineID

TheSubform has
ProdNum
ProdID
ProdDate
MachineID
Setup
Pieces
Quanity

I am trying to get the main form to list employees and hours seperatly
by shift and date. The employees are total number of employees on a
machine per shift per date. Such as 3 employees did 200 pieces on
machine3 2nd shift on 11/11/04
of ProdID145
Then Still on sameProd# 2 employess did 165 pieces on machine5 2nd
shift 11/11/04
of ProdID146
Everything is working with exception of employees and hours if I
attach it to MachineID or ShiftID it makes all Machines or shift have
say 3 employees and 8 hours.
Any thoughts or ideas would be gratefully apprecieated.
Also when I get this complete I will be using this to produce reports
on total production hous,and quanitys produced per shift daily,weekly
and monthly.
In other words tracking to compare shift production and output
Again thanks for any help

 

[Edward G]

Ken,

I am one of the least expert people here, but I have experience using Access
in a manufacturing environment. I think you are overcomplicating this. I
don't see why you are using a form AND subform. To do your data entry,
design a form that will include:
Product#, Date, Shift, Employee#, Hrs, Machine#, Qty. This is a very simple
form. And the data should be stored in a table that you might want to call
tblProduction. Your reports will require you to develop a query that draws
details from related tables. For instance, the form should only require you
to enter the Product#. Your product table will supply the query/report with
the Product Description so the people reading your report can make some
sense of it. Likewise with Employee# and Machine# although for purposes of
data entry you might want these fields to be combo boxes on your form. If
you have 100 employees and their employee numbers are relatively short, I
would probably opt for entering the employee number over having to scroll
through a combo box, especially if it means letting go of the keyboard to
grab a mouse. If you are building a data entry form, try to design it so
that the data entry person can keep their hands on the keyboard.

Ed

 

[KD]

Ken,

I am one of the least expert people here, but I have experience using Access
in a manufacturing environment. I think you are overcomplicating this. I
don't see why you are using a form AND subform. To do your data entry,
design a form that will include:
Product#, Date, Shift, Employee#, Hrs, Machine#, Qty. This is a very simple
form. And the data should be stored in a table that you might want to call
tblProduction. Your reports will require you to develop a query that draws
details from related tables. For instance, the form should only require you
to enter the Product#. Your product table will supply the query/report with
the Product Description so the people reading your report can make some
sense of it. Likewise with Employee# and Machine# although for purposes of
data entry you might want these fields to be combo boxes on your form. If
you have 100 employees and their employee numbers are relatively short, I
would probably opt for entering the employee number over having to scroll
through a combo box, especially if it means letting go of the keyboard to
grab a mouse. If you are building a data entry form, try to design it so
that the data entry person can keep their hands on the keyboard.

Ed

Edward
Thanks for your advice
The reason for the subform is that each machine will be producing
many different parts per shift and the same type part can be different
in size and quanity.
Thus I would like to have a report when I an through that shows what
each machine produced per shift and man hours required to do so