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