Refer to list of keys

[Chacal33]

Hey all,

It is a very long shot type of question.

I have 3 tables:
- Order table: OrderID / DeliveryDate / Received
- OrderDetails table: OrderDetailsID / OrderID / Product / Qty
- OrderReport table: StartDate / EndDate / List of OrderID (VC)

I would like to get a report of received orders with their details.

In the "List of OrderID", i have managed to get all the OrderIDs between StartDate and EndDate. But how could i get the details of these OrderIDs into a template for instance?

Any idea is welcome!

Cheers.

Matt

[Steve]

Use Start expressions in templates - AppSheet Help

[Chacal33]

Hi Steve,

I know of this. I have already used it multiple times.
In my app, i do not have a Ref column, but a Virtual Column with a list of OrderID. How would you make it work?

[Steve]

How does a Start expression not give you what you want?