enumlist filter

[Mark_Pathfinder]

Hi, I'm building a sales app and I have 3 tables and I need to make a partial delivery receipt

1 ORDERS tables (in this table I have the amount of the Order)

2 ORDER DETAILS table (in this table I have the products of the order; there is a column with ORDERS ID, I have a DELIVERED ENUM column with Y or N

I created a CREATE DELIVERY RECEIPT button, with a link to the form with the same ORDERS ID

3 DELIVERY RECEIPT table (similar to the orders table, there is a column with ORDERS ID. In PRODUCTS I would like to have the list of all the products in the order and I decide to insert them in the DELIVERY RECEIPT (it often happens that orders are shipped partially due to lack of products).

I don't know how I can add the list.

Come, can I do?

I have already created the automation will change the DELIVERED column in ORDER DETAILS

[Denny774]

Hey man,

you could try this:

In DELIVERY RECEIPT set PRODUCTS EnumList Inital Value to:
SELECT(ORDER DETAILS[PRODUCTS ID], ([ORDERS ID] = [_THISROW].[ORDERS ID]))