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
Table 1(List has All items) = Gallery 2
Table 2 (Bundle Database) in Gallery 1
Dropdown is based Bundle Name Column
User | Count |
---|---|
255 | |
106 | |
85 | |
51 | |
43 |