How do you join two searches?

kylejsoutham · February 4, 2018, 2:33am

Hi
As a background I am wishing to populated a dropdown box with the result of two tables. They only have one field each. So, if table1contained dog and cat and tAble2 contained elephant and hippo, the dropdown would be cat,dog,hippo, elephant.
Thanks for the help.
Kyle

fayewatson · February 4, 2018, 2:38am

Hey @kylejsoutham You can set the dropdown type to ‘text’ and then use ‘:mergedwith’ to bring those two data types together. For example, if the first table is Pet and the second table is Wild Animal, and each table has a “Name” field of type ‘text’, the dropdown setup would look like:

Type of Choices: Text
Data source: “Do a Search for Pets’ Name” “:mergedwith” “Do a Search for Wild Animals’ Name”.

kylejsoutham · February 4, 2018, 3:24am

Faye
Thanks for this. I had not set the type of the box to text otherwise was almost there. Really appreciate you stopping me losing more hair.
Regards
Kyle

fayewatson · February 4, 2018, 4:08am

Ah, I know that part has tripped me up too! No problem, Kyle!