On Submit - Add Data to New Table
Hi,
I have a form with a main section and 1 subfrom, based on another form. When I submit, I want to create new records in another table, for each row in the subform, copying all the main data with it.
For Example:
Name: John Smith
Title: Owner
SubForm
Record 1
- date: 1/2/2021
- notes: abc
Record 2
- date: 1/3/2021
- notes: zzz
On submit of the form, I want to copy like this to a new table:
Record 1 John Smith, Owner, date: 1/2/2021, abc
Record 2 ohn Smith, Owner, date: 1/2/3021, zzz
Any examples of how to do this is much appreciated.