Just to confirm that I understood correct-
You want the user to search from a list of part numbers. For example, if the the user enters ST1 as the input, a list of part numbers that have "ST1" in it should be displayed as a list and then the user can select from this.
If the above is correct, you will need a combo box control instead of a text-input.
If you can confirm , I can then test it out and help you in setting it up.
Yes correct. After the user searches a part number it queries another table and returns the details of that part number and equivalent part number. I want the equivalent part number to then query the second gallery the same as the first search box does.
I just had a look at the combo box there and it seems to be what i want. I assume its just the same search function but instead of pointing to the textbox its the combo box.
Just to clarify there are two galleries in this app.
i tested it out like this -
I created a label with the part numbers separated by ", " . (similar to your equivalent part)
I then added a combo-box and set its Items property to Split(Label3.Text,", ")
In your case, you can then set your gallery 2 Items property to Filter(DataSource, PartNumber = Combobox1.Selected.Result)
Hope this helps!
Note: Set the combo box "Allow multiple selections" to Off
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020