Solved: Enumlist select items based on parent table

Phong_Lam1 · 12-30-2021 03:01 AM

Hi all, I have 3 table .

Table Category
Table Product
Table Customer, with [Category] and [Product] are enumlist

in Customer Form, when I choose the value of Category for Example Fruit and Vegetable (IDC001,IDC002), How could I make the dropdown list of column Product show the products belong to referenced category. In this case will show Apple, Mango, Tomato,Onion options for customer to choose ? Thanks

Rafael_ANEIC-PY

Hello @Phong_Lam, you can use this expression in the valid_if() field of your Product column, it should be an enumlist of base type ref linked to the product table as well:

SELECT(
Product[ID product],
ISNOTBLANK(INTERSECT([_THISROW].[Category],LIST([ID Category])))
)

Let me know if this expression works for you, I haven’t tested it but I am reasonably confident it will work hehe, don’t forget to change the column names to match yours exactly.

The expression should also work if you ever have Items with multiple categories at once.

View solution in original post

Rafael_ANEIC-PY

Hello @Phong_Lam, you can use this expression in the valid_if() field of your Product column, it should be an enumlist of base type ref linked to the product table as well:

SELECT(
Product[ID product],
ISNOTBLANK(INTERSECT([_THISROW].[Category],LIST([ID Category])))
)

Let me know if this expression works for you, I haven’t tested it but I am reasonably confident it will work hehe, don’t forget to change the column names to match yours exactly.

The expression should also work if you ever have Items with multiple categories at once.

Phong_Lam1

It’s working @Rafael_ANEIC-PY , Brilliant , thank you a lot !