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.
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.