Create database copy so external SQL data is visible in FMG
I'm a FileMaker newbie, and I'm trying to save a copy of my FMP database to use locally on my iPad. However, my FMP database includes external SQL sources, which I can't access from my iPad offline. Anyone have some advice as to how I can create a copy of my database, or a partial copy, so that I can see the external SQL data in Go?
My end goal is to have technicians performing offline data entry, and to sync their new entries with my FMP database at the end of the day/week when they return (same as to the author's goal in this post: http://forums.filemaker.com/posts/3e5f4d4def). At some point I want to write/purchase a syncing script, as was suggested in the linked thread. In the meantime though I really need to continue with data collection, so I'm planning on using iTunes or email to transfer copies of the database back and forth. Does this seem like a reasonable way to progress?
I'd really appreciate any advice. This forum has already been a huge help, and I'm looking forward to learning enough so that I can contribute back to it as well.
I think that you would need to use Import Records to populate tables in the FileMaker Database by importing that data from the ODBC sources.