Forums

Hey All

I have a complex form entry system I need to insert.

I have a table that all entries are given a code. I am trying to create a signup form that will insert into multiple tables, and generate a new code.

For the code generation I need to get the last code created, then use php to generate a new code based on the last one.

I think I have figured out the multi table insert, but haven't figured out how to get the code generated.

Any thoughts will be greatly appreciated.

PS
I just saw that 5 is now live so will be upgrading soon.

Hi dagger2002,

You don't say where the last code is saved but assuming that it is in a database table you can probably use a DB Read action, or a hand-coded MySQL query to get it.

Bob