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.
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”.
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.
Ah, I know that part has tripped me up too! No problem, Kyle!