Value Lists and ODBC Data Sources

[WGD]

Is there a way to create a value list that will auto populate from an ODBC data source table. Currently when I attempt to create a value list, it shows the ODBC data tables in my list, but they are greyed out. I have access to these tables working for most other functions, but they will not allow me to select them as a source for seeding a value list. I've also noticed that Command i will not show indexed field data for ODBC data sources, as it does with FMP tables.

Anyone have any thought on this?

Thanks in advance.

[Tori Mitchell]

Short answer: Next version... possibly.

Longer answer: You can only do this if you have a script to copy the values from the ODBC source to a FM native table at this point. It was addressed at DevCon as something that they're working on for next version.

[WGD]

Thanks for the replay and the info, it's greatly appreciated!