I have built a multi-step form which I am wanting to enter data into a MySQL relational database across 5 tables. I am not sure on how to add the insert behaviours to work with the form, as well as binding the correct relational id’s into the relational tables.
Do I need to add separate server actions for each database table?
How do I integrate the Database inserts with the form?
To explain how this was previously done using DW and Web-assist.
- An ‘Insert record’ behaviour was created for each table.
- The Insert behaviour for table with the primary key (id) was triggered first which creates a session id with the value of the primary key.
-then for each of the next insert behaviours created for the different tables the session id created on each behaviour was used to bind that value as the relational id in the table.
Help Please.
Thanks in advance!