Return multiple values from child table

[abood89]

Hello 

Im trying to return multiple values from child table.

When i set the expression to : table name [column name] it return all values from that column.

I tried to use lookup but it returns only one value from childs record

Is there any way to return all related childs only ? 

[dbaum · Accepted solution]

Your parent table may already have a virtual column automatically created by AppSheet that uses a REFROWS expression and provides a convenient list of child rows. If not, you may not have linked your tables in an optimized fashion. Regardless, you can use an expression along the lines of the following wherever you need it:

SELECT(ChildTable[Child Key Column], [Child Key Column] = [_THISROW].[Parent Key Column])

Edited to remove ambiguity:
SELECT(ChildTable[Child Key Column], [Child Table’s Column Refernecing Parent Table’s Key Column] = [_THISROW].[Parent Key Column])