This server behavior allow users to insert data at the same time into two related tables.
The tables must have a master-detail relationship, one of the tables having a foreign key to the other.
The master table must have a primary key numeric with autoincrement and the detail table must have a numeric field to save the master table primary key value to create the relation between the master table record and the detail table records.
There are some limits on the form fields you can use for the detail form:
- Cannot use radio buttons (must be replaced with a combo box)
- Cannot use checkbox (must be replaced with a combo box)
- Cannot use file fields - This behavior don't support upload files
- Multiselect combo box (list-items)
To validate the forms fields for this behavior you must use
my Form validator
because all the standard form validator
are not able to validate the form for this behavior.