Loading Dropdown List options from DB, strange outcome

My dropdown lists are all coming up with all of the items from the DB loaded into each option box comma delimited (see image below). The right # of options are coming up, which is nice.

image

The “code” is pretty simple: Search for CurrencyTypeList :each item’s currencysymbol

I found that I can switch several of my lists to “static lists” for the purposes of loading options, but not all of them will be static, so I’d love to know if anyone knows how to get around this.

-Gavin

Presumably, you’ve done a search in the option caption, instead of just referring to the specific thing.

I did have the same query in “options” and “captions”. When I removed it from “captions”, it still displayed the same way ($, ¥, £, €, ₱, ₣) six times.

I have the DB set up as follows:
2023-10-12 17_08_03-Joshuagmoore _ Bubble Editor

Apparently it was the captions messing it all up, I didn’t see the dynamic caption option called “Current option” until I created a multi-dropdown and it was auto-filled with it. Thanks!