do you know any posts which could help with this?
my example shown above has two lists
Product Names Sub-type
Loan - mortgage
Loan - business loan
Loan - personal loan
Deposit - at call
Deposit - term deposit
Transaction account - saver
Transaction account - no fees
How do i run a list lookup on Product Group which then filters which SubType is available ?
I have spent the last hour trying to connect various combinations using the Filter by control's value but either I get repetition of the Product Names 2-3 times or the filter doesn't work and all of the subtypes are displayed ...
I have put together a video showing how the new Responsive designer will allow filtering of unique values. Hope this will solve the challenges you are experiencing.