I've searched and searched but can't find much info on my query in the forums - hopefully someone can help me.

I've been building a database to log the flights our helicopter company does. We have a current Access system but having been built closer to 2000, and ported use from another department it is time for something much better.

We're making great progress developing what we want on Filemaker, which brings me to my question.

We were hoping to have a cut down version of the database running on an iPad in the helicopter so that crews could log the exact times they go off and back on at jobs with the touch of a button, aircraft start up and shut down times etc.

Obviously this would be offline. With Filemaker Go having no syncronisation capabilities. Is there anyway this can be accomplished? Could a script be created to import the data from like a holding database into the main database upon being reconnected?

Any ideas would be appreciated, this is a major selling point to the boss for our new database, but I'm starting to wonder if it's possible.

One of the criteria is that it needs to be really really simple, we have many users with only very basic PC skills, and even less skills on the mac!

Cheers,

Andrew

Edited October 27, 201015 yr by Guest

since a helicopter could have one user at any one time, the ipad could have a local database and you can create a record in the local database with timestamps etc.

You'd want to use a true UUID - See Ray's UID custom function

http://www.nightwing.com.au/FileMaker/demos9/demo910.html

When you land and get in to the office you could connect to your hosted DB w/ a script to push the local data to the server.

Thanks Stephen for your reply, really appreciate it.

That script looks the goods. We have five helicopters and around three running at any given time, but I'm assuming this script should take care of any problems with conflicting primary keys.

Cheers!

Andrew