Add rows to child table

[RayMR]

Hi,

I have a “Product” table that has a column named “Type” which is an enum list. So, IE a product can be many types or just 1.

I also have a “Unit” table that has a column named “Type” with valid if expression to select just one “Type”

Then finally I have a “Items” table that should populate rows with all of the “Products” that match the “Type” selected in the new row added to the “Unit” table. So the “Items” table is a child of the “Unit” table.

When I try a filter expression such as this - FILTER(“Product”, ([Type] = [_THISROW].[Type])) I get an error Cannot compare List with Ref in ([Type] = [_THISROW].[Type])

TIA

[AleksiAlkio]

Not 100% sure what you are looking for, but at least you should write it like..

FILTER(“Product”, IN([_THISROW].[Type],[Type]))

[RayMR]

Nevermind - I set up another table for the “Types” and referenced that table to select the type.

Thanks for the help!

Thanks! It does bring in the multiple products into the child table, but when I select from the enum list I am getting every combination of enum lists instead of just the single type.

The issue is going to be that most of the Products will have multiple types. I wanted to be able to choose either ADA, CT, VTOP, R as single options and then all products with that type would be added to child table