Same store data for multiple employees

S

Supe

I have a form where the top you select the store number from a drop down and
it populates the store information(address, city, state...) using a VBA code.
The bottom of the form has 10 rows where an employee name is put in one
unbound box and the hour worked in another unbound box. How can I save this
to a table so that for each employee and hours that are entered, the store
information listed on top is also included on that line in the table?
 
J

John W. Vinson

I have a form where the top you select the store number from a drop down and
it populates the store information(address, city, state...) using a VBA code.
The bottom of the form has 10 rows where an employee name is put in one
unbound box and the hour worked in another unbound box. How can I save this
to a table so that for each employee and hours that are entered, the store
information listed on top is also included on that line in the table?
Click to expand...

Ummm...

Don't.

The store information should be stored, once and once only, in the stores
table.

It need not and SHOULD not be stored redundantly in a table of employee hours.
Instead, use *bound* controls in a Subform bound to a table of hours, with
fields for the StoreID (the master/child link of the subform), EmployeeID
(from a combo box), and Hours for that employee.

John W. Vinson [MVP]
 
Top