I'm working on a project in which I'm going to collect data for more than 1 table and multiple records in some of the tables.
I've learned how to collect the multiple records so now my data is being posted like this: ID, Date, Misc, textbox1, textbox2, textbox3 and so on and so forth where textbox* needs to be inserted into a child-table and ID, Date, and Misc will be inserted into a main table. There could be any number of textbox fields.
I was thinking all of this data would be posted to a second page with an SQL statement to insert data into the main table and another sql statement nested in a loop to insert each textbox (along with IDs) into the child-table. I've read here that sql inside a loop isn't always the best idea, but I can't imagine another way. The data does need to be in separate tables in an access database.