Submit a form with many records

[sirhc]

I am creating a form for workers to enter
1. Username
2. their activity, and hours
however they do many activies and different hours in each. how can i submit it all into database

 

[BoroLee]

Try splitting the tables so that one table has details about the worker (I.e. Name, Address etc), and the other table contains there working data. Thene link the tables using The Employee ID field, and you can then create a form and subfrom to allow numerous work patterns to be enetered against one employee.

Hope this makes sense.
Lee.

 

[sirhc]

The tables are split but with the form i can only save the username once in that field and the rest of the work_done and hours_worked get saved without a username as a key or reference. sorry i maybe am not describing this properly but i am not sure how to proceed
my form looks like this

username: ________ Date: __________

work_done hours

1__________ _________
2__________ _________
3__________ _________

submit_button