Filter Gallery using DropDown and Many to Many relationship
Could you advise on how to filter a Gallery using dropdown and from a many to many relationship.
this is the current filter I am using
Currently experimenting with the above picture. I have table 2, as the gallery 1 on the left and table 1 and as gallery 2 on left. I am using the dropdown to filter gallery 1. which shows data on Gallery 2 (Gallery1.Selected.'Standard Product Pricelists')
Now I am trying to take out Gallery 1, and just use Dropdown directly to filter Gallery 1. they have a many to many relationship between the 2 tables. but I can't workout how to do it
I have tried using this
LookUp('Bundle Databases', 'Bundle Name' = 'Product Name').'Bundle Name' , but no luck