dropdownbox internal form populated from database table?

[Mservices]

Hi,
Found a similar question, but without a reply.

I want to have a dropdownbox in my internal form with all the cities in my region. There are 139 cities, do i have to write them myself or is there a way to populate this dropdownbox from a database table where I've already stored them with the corresponding provinces?

Thanks for any reply/help

[bill09]

You could just create another form and import* the cities into it, then connect it to the original form under Fields, Dropdown Settings, Option List / Contents, then select the city form/field from the options under Form Field Contents.

* Import something like this:

ft_form_4 = your city form table name in FormTools
my_cities = your existing table of city names

INSERT INTO ft_form_4 (city_field) SELECT city FROM my_cities;