3 tables with related data

Trying to generate a coherent data set with 3 different tables.

form 1:
id
first name
name

form 2:
id
street
city

form 3:
id
phone
message

Of course, each form is more extensive.

If I go to save when I enter form 1, I want to go right on with form 2. Form 1 and 2 must then be linked together. So of course then with the 3rd form.

I know that this is possible. Only I have no idea when it comes to the implementation.
Is there perhaps a tutorial for this?

Translated with www.DeepL.com/Translator (free version)

Use the Form Wizard

Now that’s practical.
Is it possible that I can show entries from the 1st page above on the 2nd page (e.g. first name and last name).

Yes just save a Session variable and display it in the Header

So on Page one On validate:
[firstName] = {first_name_field};
[lastName]= {last_name_field};

Then on Page 2 Header do this:

Select the header to be a Defined Value and put in: [firstName] [lastName]

Ui… a new challenge :wink:
Give it a try.

I always get an input screen for the session variable.
How can I display this only in the 2nd and 3rd page?
Apparently, my solution wants to display already in the 1st page, where the data is first collected.
I am trying under layout header and footer to display the variable.