- Submitting SQL queries to another database to import data to your FM File is a breeze - go for it. I use it all the time, couldn't live without it, etc.
- Using FM as an SQL server used to be an absolute dog. I finally gave up complaining about it. The simplest of queries seemed to end up in endless loops of 'Summarising records...'. Would love to hear that it was now fixed. (Was made to feel like An Old Codger: the answer I was always given was "Oh, aren't you using XML now?" Well, I've stuck with Filemaker for 15 years because I'm an engineer, not a scientist. I just love the way it works and let's me use it as a tool. I have no interest in going to night-school to learn XML programming, thanks all the same.) I'd love to hear that it's all now fixed as an ODBC server.
BTW the reason they said they couldn't fix it was because 'The ODBC driver was written by a Third Party'. (No, me neither...)
If FM10 as an ODBC server works for you, I've got a Purchase Order and a whole pile of projects lined up for myself!