Is there an example of doing a many to many data entry and Updating records or adding records to other tables as a transaction after saving? So no updating or adding if there are problems saving from the many to many or one to many data entry, just like the Order Header and Order Detail on the Northwind database. Thanks!
See:
Intro
Form repeater can be used in update record forms in order to easily update nested data to your database table.
Similar to our Insert Data tutorial - we will show you how to update a user and its contacts - so make sure to check it first, before continuing here.
The user will be stored in the main table, while its contacts will be stored in a sub table.
Overview
We created an update record page with a list of records an a form:
[Screenshot_93]
Our dynamic list gets its data from a …
And the working with multi references to make many to many relations:
Intro
Thanks to multi references in the Database Manager you can define many-to-many relationship between items in two database tables.
With many-to-many relations an item from one collections can be referenced to more than one item in another collection. Simple examples:
Authors and books - a book may have one or many authors and each author may have written multiple books.
Actors and movies - a movie has many actors and each actor may be playing in different movies.
Students and classes -…