I am modifying the sample inventory app and added “Item” columns in the “Sales” table to reflect the same in the “Product List” table.
I have used the following and cannot get the referencing to work accordingly:
Virtual Column: "GetItem" (List) = REF_ROWS("Product List", "Barcode")
Wherein the GetItem intends to search through the Product List based on the Barcode column and then go to identify the Item:
Column: "Item" (Text) = [GetItem][Item]
Where the Item is found and assigned to the column.
All help is greatly appreciated.