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.
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.