FileMaker to FileMaker ODBC query
Who can walk me through how to do this, step by step?
Are you using Server (you make no mention of it in your other post)? My understanding is that FM can only be an ODBC host when running server. And it that's true, and it is FM -> FM, what are you trying to achieve that can only be achieved by needing FM to be an ODBC host?
It was a question that came up for me when setting up ODBC in FileMaker Pro 10. I understand you correctly you can only query FM -> FM Server. I was trying to achieve "live" interaction between two separate FM databases. I am guessing the way to do that is FIle ->Manage ->External Data Sources (Type: FileMaker). Is that correct?
If you've got the choice from the start, have them as tables in the same file, but if they are alreday estables separte files then FIle ->Manage ->External Data Sources (Type: FileMaker) is correct.
Retrieving data ...