Multiple Table Entries From One Form Entry?

[JonWolgamuth]

I'm developing a form which lists various tasks and the quantities of tasks completed. There are 30 or so of these transactions. I have created a tabbed form which separates the transactions by type.

What I want, is for users to be able to enter the quantities next to the transactions and to save the data all at once. One day's transactions should be able to be saved, creating multiple table entries. I want a table entry for user's name, date, transaction type, and quantity.

Is this workable? If so, how might I go about it???

I have a table of employees, and transactions, to go with my table for work entries.

Many thanks for any help anyone can give me!

Jon

 

[LonnieJohnson]

If all the tables have a common field, then Tab one could be general information or the main table's data. Then the rest of the tabs could be subforms to the rest of the tables. This is a simple approach and may not apply to your situation.

Just a thought ljprodev@yahoo.com
Professional Development
MS Access Applications

 

[JonWolgamuth]

Thanks for the response, Lonnie. However, I would like to be able to just have one table (WorkTBL) which contains all the data. I can't figure out how to get the form to add the proper information to the table...It's hard to put into words what I want the form to accomplish for the end user. If I could post a screen shot, I think people would understand my dilema...

Aarrgh!!

Jon W.