Same store data for multiple employees

G

Guest

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?

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top