First off, what you re trying to accomplish will not be done entirely by DataAssist, you will need to do some manual development on this.
I would not create the form with First applicant details on one side and Second applicant details on the other side. I would break it down.
create an application table, this holds data unique to the application.
Create another table for the applicant information, this table will hold the personal inforamation for each applicant. It will have a foreign key relation to the application table to relate the applicant to the application.
The first form will be the application form, they will fill in all of the information about the application except for personal details.
When this is submitted the DataAssist server behavior will insert the application data to the application table. In the DataAssist Insert record server behavior, there is a session variable section. This is used to store the ID of the inserted record into a session variable, select the application ID column and the name to store the session as, remember this name.
The insert record server behavior will redirect to the applicant insert page. On this page is a form to fill in the applicants personal details. When this is submitted, the insert record behavior will store the personal details in the applicants table. For the Foreign key column that relates to the application table, bind to the session variable that is created by the insert Record behavior on the application page. Either leave the redirect blank or on the redirect page, offer a button to go back to the applicant insert page to add another applicant to the application.
So the work flow will be:
Create the application -> Add Applicants personal information -> Add additional applicant personal details or finish.
