registration and insert data same time

Hi,

What is the best procedure to do a full registration form and have all data go into 3 different tables while still having security assist create the forgot password and all the pages it does. I need the full registration of adding/managing users like on powerstore.

table 1 - users
table 2 - parent info
table 3 - detail info

I am using:
security assist
dataassist
digitial file pro

I looked at the security assist pdf but that didn't show me how. It did say look at Using SecurityAssist with DataAssist but I couldn't find that one.

If there is an easier or better way of doing it? Should I be using DA insert multiple? Should I use DA first 3 times to insert the data in all 3 tables, then SA?

Would it be wiser and simpler to create a simple registration page and then create a full registration page after that? (ie: run DA first with multiple insert, then SA for creating user/pass)

Thanks,
Ed

For this you will need to edit the registration page that is created by security assist.


you will need to delete the Dreamweaver Insert Record behavior that is applied, and replace it with the DataAssist insert record behaivior. This is covered in the Solution recipe on the security assist support page in the Modifying registration video:
securityassist/

(Note: This video uses encryption for the password field, you dont have to follow that part if you dont wish to encrypt the password).

Make sure that the insert record beahavior does not have a redirect set, and make note of the Session name that will be created in the store as section, this session will contain the id of the record that is inserted to be used in the foreign key column of the other tables.


Now you will need add the additional form elements to collect the data that will be store in the other tables.

After these elements are added, add another Data Assist Insert record behavior for the parent info table, bind the parent info columns to the parent info form elements, then add a third insert record behavior for the detail info table, binding the detail info columns to the detail info form elements. In both of these insert record behaviors, bind the foreign key columns that relate the info to the user to the session created by the user insert record behavior.


In the last insert record behavior, you can set the redirect to go to the login page.

I want to make sure I go forward correctly so
I've done everything and I'm on this step:
After these elements are added, add another Data Assist Insert record...

1. Just to clarify, do I use the DA insert single record for each of the 2 tables (not the multi)?

2. For the store as: do I put the same one that was created earlier you said make a note of for each DA insert record?

3. Each of my 3 tables has a Uid field which I made so they are all the same in addition to their own specific Id fields for each table.

How do I do the following you stated:
In both of these insert record behaviors, bind the foreign key columns that relate the info to the user to the session created by the user insert record behavior.

Is this the right way - in step 2 of DA insert record: do I click on Uid > value lightning > session > pick the session made earlier ?

Do I do this same step for the 3rd table too?

Thanks

1) Yes, use the single record insert

2) No, for the store as, the names should not be the same.


3)

  Is this the right way - in step 2 of DA insert record: do I click on Uid > value lightning > session > pick the session made earlier ?  

yes, that is the correct way.


yes, use the same step for the 3rd table too.

thanks for your quick response,

my third table is actually a kid table and I need my form to be dynamic so if one parent has 1 kid or how ever many, I need to be able to add more kids accordingly to that same registration form and simple enough so I can make it.

It would be nice to have another set of text fields generate when a plus sign or something is pressed. Do you have a suggestion how to get this put into the same form?

There is no built in support for dynamic forms like this in Data Assist, it would require creating the code by hand to accomplish.

Ok thanks for the help

could I just create it with 1 kid on the registration page and then use a insert record on another page to insert another kid?
How can DA make sure it's going to the same parent? or Uid

Yes, you could insert aditional kids using a second form.


you would need to pass the Uid of the parent record to the second form, probably as a query string variable to the second page, make sure the forms action passes the queruystring variable as well and use that in the insert record behavior to assign the correct Uid in the inserted record

Ok I thought of another way maybe,

I am following the solution recipe for DA
Inserting multiple records (Interactive Tutorial)

Because I am going to make room for adding 4 kids on the registration form and hope there is no more, and then specify DA multiple insert to skip if empty -there is no data in any form fields of the repeat region (ie only 2 kids present). But in skip if empty I can only pick on table field, not the entire row of fields, does this mean that if one of the fields is empty it will skip all of the row?

So I have created the repeat region just for the 4 kids below all that other registration info and I am at this point:

So far I have
-all my form fields
-1 DA insert single record for table 1 users

Since I am taking a slightly different approach, what should I do next?
Should I make
-1 DA insert single record for table 2 parents
-1 DA insert multiple record for table 3 kid and redirect to go to login page


thanks

  Since I am taking a slightly different approach, what should I do next?
Should I make
-1 DA insert single record for table 2 parents
-1 DA insert multiple record for table 3 kid and redirect to go to login page  

yes, that is correct.