See the results of the child rows of a table in a different table

[anonymous]

Hi Community,

Parent 1 is the nonconformities table and has 2 Child Ref rows :
Child 1 are the non-compliant parts.
Child 2 are my corrective action.

I would like to see the list of the parts and qty from Child 1 into my Child 2 form.

What would be the best way to do so?

Regards,

[Steve]

Create a virtual column in Child 2 with an App formula expression like this:

[Parent][Related Child 1s]

[anonymous]

I see this error message :

[Steve]

A’ight! Let’s try this instead:

FILTER(
  "Child 1",
  ([_THISROW].[Parent] = [Parent])
)

[anonymous]

Thank you Steve, it works!