Forums

Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

Save 1 to 1 DB Relation

igmz 12 Apr, 2018

Hello.

I have to tables in mi database:

MAIN with an ID
MAIN_DETAILS with a forgeing key to MAIN

I have a form to get both table data so I that I want to do is save first details to MAIN table and after save data to MAIN_DETAILS with the fk included.

Please, anyone could help me??

Thanks in advance!

Max_admin 19 Apr, 2018

Answer

Hello igmz,

Just use 2 "Save data" actions, after the first one the id value should be available under:

{var:save_data_name.id}

You can use that in the "Insert data override" of the 2nd "Save data".

You can check the whole list of available variables by using a Debugger

Best regards

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?

igmz 20 Apr, 2018

Many thanks!

This topic is locked and no more replies can be posted.