Filter list of SKUs by Customer

[LLD]

I'm stuck... I have 3 tables - 

1. Reference table (List of SKUs) - [Customer], [SKU], etc.
2. Parent Table (Customer Production Log) - [ProdnID], [ProdnDt], [Customer], [StartTime], [EndTime], [Duration], etc.
3. Child Table (Detailed Activity Log) - [ActivID], [ProdnID], [SKU], [Activity], [Quantity], etc.

As I make entries into the Activity Log, I need the SKUs to be filtered by customer.. the link being [ProdnID].[Customer]

How do I do this?

[Marc_Dillon · Accepted solution]

https://help.appsheet.com/en/articles/961554-dependent-dropdown

[Marc_Dillon · Accepted solution]

https://help.appsheet.com/en/articles/961554-dependent-dropdown

[LLD · Accepted solution]

Thanks Marc.. the expression I used in the Valid If column was...

SELECT(SALES_SKUS[SKU], [_THISROW].[ProdnID].[Customer] = [SKU].[Customer],TRUE)