All,
I've been given a great solution to a previous problem in this thread but a new requirement has been added to the form. My supervisors want the ability to record multiple types of production hours for each employee by day on one form. Thanks to this forum, I achieve the multiple records on one form. Unfortunately splitting the hours has left me quite stumped.
At first I thought I would create unbound text boxes to key in each type of hours worked for each employee's daily record. That did now work as the data updated for all rows of the unbound text box in the form. My next thought was to create Dummy fields to associate with the records, which worked, but also causes a normalization issue. My thought to fix the normalization issue is to have some kind of DoCmd.RunSQL function create two new records based on the textbox control it's associated with: textbox1(ProdHours) would create a record for Production Hours, textbox2 (CleanHours) would create a record for Cleaning Hours. \
The SQL function RespCode (responsibility code) associated based on what they were doing. That would fix the normalization issue, but I can't figure out how to do it.
Here's what everything looks like:
The first three records are what the form outputs currently. The last six records are what I would want the SQL function to spit out. I would then run a delete record query if the RespCode field is null.
Any thoughts on how to achieve the SQL part of this?
Thanks!