valuelist from mysql table

[Waki]

Hi, i've a FM9 solution, with some mysql datq, is possible to define a value list with value from a field of a mysql table ?

thanks

[Fitch]

A lot of people have requesed that, but no, you can't at this point because the fields from the external data source aren't indexed.

[LaRetta]

A work-around would be to import the field into FM table (used just for this purpose). It would not be dynamic but an import/update can be ran and, depending upon the size (SQL can be dawg-slow) and how often the data would change, it might be workable.