I'm not really sure how to word the question but here is what I have.
- Two dropdowns. One for Medium and one for Medium Details
- Medium has a primary column named Medium Name which contains values such as Banner, Video, Text Link, etc....
- Medium has a secondary column named Medium Detail Type which contains values such as img, vid, lnk
- Medium Details has a primary column named Medium Detail Name with values such as img-1, img-2, img-3,vid-1, vid-2, vid-3, lnk-1, lnk-2, lnk-3
Initially, I was trying to make the Medium Details dropdown dependent on Medium by using a formula like this which worked when I was using comboboxes:
Filter('Medium Details', Medium_CB.Selected.crfeb_mediumdetailtype in crfeb_mediumdetail)
Besides this not working I didn't think it was efficient. Since then I added to the Medium Details data source a column for Medium Detail Type.
What I am looking to do now is return the Medium Detail Name where both Medium Detail Type from both data source match. I've a number of searches and tried a number of solutions but I'm just not landing on the right one. Most of the cascading tutorials out there are not comparing secondary columns.
