Originally Posted by
msmayhew
I have two tables: SalesDrivers and SalesDriversData.
The sales drivers table just has two fields. DriverNumber and DriverName. The data table has an ID field (Primary Key), Driver Number, PalletsIn, PalletsOut, CratesIn, CratesOut, etc....
I know, traditionally, the way to update this data table with a form is one record at a time. But the client has requested to have one form with a row of controls for each driver. I have the form set up and it works fine. It has a submit button that executes a SQL statement for each driver (or row of controls).
The problem is adding/removing drivers. Right now it would take forever to add a row of controls and name each control, then add the code to execute the SQL statement.
I want to be able to cycle through the drivers in the SalesDrivers table and add each row dynamically.
Suggestions?