How to show a related table in the form?

Roxanne Bayron

Sep '24 • Stuck or Need Help

Hi,

I'm trying to preview all checklists submitted in my app so users can double-check their submissions.

I have attached an image of how these tables are related.

Process flow:

The checklist name and ID are stored in a checklist table when a user conducts a routine check.
When a user answers all the questions in that checklist (32 questions), those questions will be stored in the checklist items table.
If there is a deviation from the checklist items, a record will be created in the action log.

Attached is the screen in my canvas app, and as you can see I was able to show the data in the checklist table only, I want also to show the checklist items related to that checklist. How to that in my form?

In the item property of the form I have Gallery. Selected.

6 comments