Hi,

Is there a way to only import information if it is newer than information in the existing records?

The users of the database I'm making want to import a set of records from another office periodically - say every three months. They will be constantly be re-importing from the same set of records with whatever additions and updates have been entered since the last import. I understand how to create the match so existing records get updated, not reimported, but if the users of the new database have updated information, I don't want to reimport the old information. There is a modification date in each file, so I figure there must be some way to compare them, but I can't figure out how.

Also, I want to script the import so it doesn't have to get set up again each time, but I can only find instructions in the manual for importing scripts, not scripting imports! Any suggestions?

Thank you in advance,

Leah

The secret here is that FileMaker will only import the Found Set from the other database, so you will have to call a script in the file you're importing from to find only those records whose modification date is equal to or later than the last update, then import those records.