Copying autoincrement ID value to another column when inserting a record

Hi Ray, I have three ID columns in a database, the first one is the primary index autoincrement ID, then I have two other INT columns, say they're called ID2 and ID3. These are used to give people access to specific areas of the website. I have it set up on the record update page so that when someone requests access to these areas, it copies the primary index value into the other two columns. However, how can I get the value of the primary index when adding a new record? Is there a way of getting this number when it doesn't actually exist until the record has been added?

I'd just do an update after the insert and save the inserted ID into the session so you can update the record immediately after.

Thanks Ray, I'll add a note to the insert page so that admin users know to do this.

You don't need to add a note... You can apply the update server behavior on the page with the insert so it happens automatically.

Ah of course, hadn't thought of that!

Just make sure to remove the redirect in the insert if you have one and put it into the update instead so it has a chance to run.

Just had a mental block - would I be right in thinking that in the Update behavior in the attached page I would put <?php echo $_SESSION['WADA_Insert_para_users']; ?> in the Lookup value section, and also in the Column Bindings for the two columns where I want to copy the ID? I'll move the redirect to the update behavior once I've added it but just want to make sure I'm using the correct value.

Yes, that sounds correct.

It works, many thanks!