I have three tables Products, Order Details, and Customers.
On my Customer table I have a Enumlist Column with base type of Ref that links to the products table. The idea is that each customer has specific SKUs from the products table. This column has
Products[Id]in the valid if constraint so as to populate the list.
Next I have an Order Details table where the user will select SKUs and quantity for a customer. I should be able to select the appropriate customer SKUs with this expression
Select(Customers[SKUs],[Name]=[_THISROW].[Customer]), however I just get an enumerated raw list (see below)
I have tried a lot of troubleshooting with base types and ref. For example, changing the Order Details column from Ref to Enum (with and without base type ref). I am not sure if this is a limitation of the Schema of my products table but it feels like it should possible
p.s. I hope everyone is staying safe and well