Get data from child table

[Fusion_Incense]

I have 2 Tables Customer(parent table), Order(child table) has CustomerID for Ref.
I know in child table I want to get parent table data, I just use app formula [CustomerID].[xxxxxxxx]
but what about other way around?
Currently I’m using any(select(Order[xxxxxxxx],[CompanyID] = [_thisrow].[CompanyID],true))
what if I use lookup formula? is the sync time will be faster? My app keep getting timeout, when I check the performance data, it’s the VC causing the hang.

[Aleksi]

When you use the syntax TableName[ColumnName] it needs to read the whole child table. Instead of doing that, you can read only your related child virtual table (only few records). Then the syntax is like…
SELECT([RelatedChildRecords][xxxxxx],TRUE) and it will give you the list of [xxxxxx] column’s values.

[Fusion_Incense]

@Aleksi Thank You!

[Aleksi]

You’re welcome