Two page form

Hi Im using DW CS5.5 plus latest versions of all extensions.

What would be the best way to do this: I have two forms. The first form has 4 fields, name, tel, postcode, email.

Filling in this form (form1.php) successfully I would like to have this form emailed and the data saved into database. After that the second form page appears (form2.php) which is a larger form asking for more details. After filling in form2.php, an email is sent and the data saved into database again which actually joins all the data saved from form1.php.

if user enters form2.php in the url, it would jump to index.php page where form1.php is. Both forms have been made and validated already.

I know I have add hidden fields on second form, Im just confused as to saving data and emailing redirect on the forms.

Please advise, appreciated.

on the first page have the form set to post to itself. use the Data Assist insert record behavior to insert the form data, In the insert behavior, you can set a session name to save the ID of the inserted record, make note of this session name. then the Universal Email behavior to send the email, in Universal Email behavior, set it to redirect to the second form.

on the second form, again, post to itself, and use the insert behavior to save the form data. Int he relationship column, bind to the session set by the first insert. again use Universal Email to send the form data.

if you need help in setting this up, we can help through a premiere support appointment:
http://www.webassist.com/premier_request.php

Thanks for the reply, Im using MySQLi extension and have recordsets on the form pages. Would using data assist record behaviour have problems with mysqli? Can I use mysqli > data management > insert behaviour instead of using data assist?

Yes, you can use the MySQLi insert behaviors, they will also be able to save the inserted ID to a session.

Great. Please tell me where the relationship column is?

I can't tell you that, you would need to tell me that. I don't know the structure of your tables.

but where you inserting to 2 tables, the second table would need a column to create the relationship. an example would be a products table and a categories table:

categories:
categoryID - primary key
categoryName

Products:
productID - primary key
productCategoryID - relates to categories.categoryID
productName
etc

in this example, the productCategoryID column is the relationship column that creates the relation of the product to the category.

I see. I would need to create the relationship id in the second form. thanks

Yes, that is correct.

Ive submitted a premier support ticket, please advise.

I Have passed this on to Ray, he should be in touch to schedule the session.