ODBC data and drop-down lists

[Sefu]

Dear All,

I am an absolute Newbie in FMpro - apologies in advance if the answer to my question seems obvious.

I am using a remote mySql db as a source (through ODBC) - my attributed fields display data fine, but when I try to give any of those fields an auto-fill or drop-down menu option, I come across a myriad of roadblocks: the source can't be indexed (tried doing this even on the remote server) is the foremost problem. I got the idea that I would have to somehow import data through a second FMpro-created field (that could be indexed), but I always get an "unrelated table" message.

Also, I have yet to find any "entry-level" ODBC/fmPro tutorials - can anyone point me to one?

Thanks in advance, best,

Sefu.

[mr_vodka]

See if this thread helps you any.

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

Import the External data into a temporary table.

[Sefu]

Thank you so kindly for your reply - I finally got it working. All I needed was the values for one column (for certain fields), so the import didn't take hours... thanks again!