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.

2Checkout.com

2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for goods and services provided by ChronoEngine.com