Value lists from external data sources?

[marcsi]

Hi All,

We're in the process of migrating our fm tables to mysql, however we'll have to carry on using fm for a while and so we need to link the external tables back to fm.

I had a table called membership_types in fm which I duly moved to mysql with all it's data and then linked it in the fm database. However one of my value lists used data from this membership_types table (when it was still in fm) and when I tried to do the same with the linked mysql membership_types table fm wouldn't let me (external tables are greyed out when trying to select a table for the value list).

Is there some sort of workaround so that value lists could display data from external data sources?

Many thanks in advance.

Marcsi

[mr_vodka]

Yes, you will have to bring the data back into FikleMaker unfortunately or at least temporarily...

http://fmforums.com/forum/showtopic.php?tid/193518

[marcsi]

John thanks very much for the response, I shall do that at least till the next version of fm (fingers crossed).