Buy Now
Sign in

Save 1 to 1 DB Relation

igmz , April 12 at 08:25
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!
Hello igmz,
Just use 2 "Save data" actions, after the first one the id value should be available under:
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
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
Many thanks!