Basic question: Automatically linking info from multiple tables into one

I would like to have one table in a base display information from multiple tables in the same base (or another if that’s the only way to do it).

My situation:
We have an online ‘program’ and participants complete a series of forms to complete each step - each form is its own table.
We’d like to have one table that gives us a ‘snapshot’ overview of each participant’s progress in completing the forms.

The only way I can see doing this is by creating a “Link to another record” field and manually selecting the participant each time. Is this right?

If there is a trigger or other automation we can set up, I’d love some help!

Thanks

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.