Store form data in the database

Hi, with chronoforms I store data in the database. In this way I need the last auto_increment ID of the actual data record to update it in the next step with other informations. I code it in the On Submit code - after Event.

In details:
With the form I store data in a new table 'content_details'. In the On Submit code - after Event I store same extract of this data in the Joomla-baseline table 'content'. After this insert I get the last auto_increment ID of the table 'content' to link this data record with the referenced content_detail. Problem is, that in this time the table 'content_details' is not saved in the database.

Are you have tip to solve this problem?

Hi jesser,

This problem has been discussed hare many times before.

You can change the order on the RunOrder tab to make sure that the DB Connection executes before the OnSubmit After Email block.

ChronoForms also makes all the saved data, including the new primary key, available to you in a data object.

Bob

Thanks for the tip! Now the form runs very fine!

Best regards
Jürgen