Hello Friends,
Sorry for the confusion created. The form is created for users to input values (or insurance quote information) and to return a premium. The entire purpose is to improve the functionality that stores all the values on a quote into a table which allows users to retrieve later. (i.e retrieving these values on a blank new form again). The tables would look something like this.
Reference Number | Driver Name | Driver Address |
12345 | Allan | 123 ABC St. |
When users retrieve, the code is basically getting these values(e.g Control.Name is [Driver Name], Control.Value is "Allan") from the table and putting that on the user entry form. Currently, we're writing one line for each control name and value which is quite annoying when the requirement is to add 10 new pieces of information being collected (e.g Driver Age, Driver Gender)
I want to write a loop to collect all the control names and values and then store them in a table, and using a similar loop to retrieve these values on the form. I wanted to check the ordering because 1) On the form users click something to retrieve, it would be nice if the reference number should show first. I figured I could get this sorted by how the table is displayed on the form. 2) If the order is messed up, the SQL query would look like this
INSERT INTO
table_name (Discount1,
DriverName,
Discount3, ...)
VALUES ("MultiVehicle",
"Allan",
"Hybrid", ...);
which isn't a bigger deal since they will still get inserted correctly. But maybe I wonder if I do little work here, it might be easier for future debugging if they are in correct order? (Discount1, Discount2, Discount3 -something like this)