Solved: Dependent Dropdown between 2 tables dependent on v... - Page 2

DPM_reports · 03-04-2020 04:19 AM

hi,

i have 2 tables,

in table 1, i have 2 colomns namely order ID, status

in table 2 i have a similar colomn named order ID.

i want to filter the values that table 2 colomn named order ID calls from table 1 of only those whose status is = completed in table 1.

can someone help me with an expression

Suvrutt_Gurjar

My request to you will be to evaluate use of referencing if feasible.

Also I believe, community will be able to suggest better if you can furnish more details about your table structure such as if you have parent child relationship in your app between these tables etc.

It may be difficult to suggest exact or proper solution without knowing more details about the table structure and their relationship with each other…

In general, I believe, you may wrap your expression with ANY() if the SELECT() statement is likely to return only one value from the [Bags] or you may wish to make the Bags column in table 2 as Enumlist type or a VC depending on your app. structure and requirements.

ANY(SELECT(table 1[Bags],[Order ID]=[_THISROW].[Order ID]))

View solution in original post

Dependent Dropdown between 2 tables dependent on values of another colomn in one table