MX Kollection Forum :: Trouble with Multi Part Form

I really need some help here.

I need to have a user go through 4 forms, each one inserting into two tables. The main information from each form goes into a different table, and also a second table that just stores the ids of each of the records inserted over the course of the steps, plus the userid (so we know what records from each of the forms belongs to a particular user).

step 1. insert into first table, and then insert the userid ( I guess use the session from the login) and id for the record just inserted into the table storing the just the ids.

Step 2. insert into second main table, and then UPDATE the second table with the id of the second record just inserted.

Step 3. Same as above, and so on.

So how do I get the identity of each record inserted over the course of the steps and also update the table storing just the ids?

I hope that's clear.

Thanks,
Doug

The HARD way will be using if conditional region on each form.... do you code php manually ?

This is actually for asp vbscript. I've created a table that just stores the ids for each of the records from each form and the userid. I guess i was just planning on doing a lookup on that table to see if the value was greater than zero, if so, update, otherwise insert.

Initially they register, and proceed to the correct form based on their chosen usertype (using a redirect), and then use the insert into two tables (get the idetinty of the first form and insert it into the holding table with their userid), and then proceed to the next, etc.

Then in their account, I hope to loop through their records, and let them add another record (using the above method), or update a current record, determing whether a form need to be an update (based a value in the holding table greater than zero), or an insert (based on a value of NULL).

I'm using MX Kollection 3.71. Is this a viable way to accomplish this?