I’ve created a basic form that allows users to request documents to be created, the form asks for basic information – their name, department information, contact info, etc. As part of the form they can request how many documents to be created. If they request 4 documents to be created, I want 4 rows to be added to the base table, copying all of the information in the form–just doing it 4 times.
In the table, the almost all the columns should be duplicated with the name, department, contact info, etc, BUT, I have 2 columns that allow for the auto increment of document numbers.
Could you provide me with details on how to automatically duplicate rows based on the information provided in a form?