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.
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.
@Aleksi Thank You!
Youโre welcome
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |