AnsweredAssumed Answered

Cascading Value List with Linked Data Sources

Question asked by laguna92651 on Jan 7, 2017
Latest reply on Jan 9, 2017 by laguna92651

My Accounts layout has a portal that lists all products, Product_Lines table, that the Account is interested in.

I have a second layout that lists all products that have been entered in all of my Accounts.

The layout is based on the Product_Lines and the Account names are retrieved with a linked Account table.

Product Search.png

I am trying to set up cascading value list.

The first value list is Products which is in the Product_Lines table, which is straight forward.

The second cascading value list should show all Industries of the filtered product find, Industries is in the Accounts table.

 

I can't figure out how to filter the Industries value list. There is no Industry data in the Product_Lines table and there is no Product data in the Accounts table. The Accounts and Product_Lines tables are essentially one blob of data linked with ID_Account.

 

I can't link the T35zza_account_VALUE_LIST_INDUSTRIES TO to the T35_ACCOUNT_PRODUCT_LINES TO, to retrieve the filtered industries list.

Product Search TO.png

Outcomes