I've got a Filemaker Client robot running that automatically maintains a number of files consolidated from several disparate systems on different servers. The files contain a number of tables, and some of these have a hundred or more fields - they are updated on a nightly basis.

I'm looking for an efficient way of being able to create shadow copies of these files into an identical data structure on another Filemaker client. The shadow copies will have identical table structures and relationships, so the user on the local client can do 'what if' scenarios without jeopardising the original data.

I can't use import/export as there is no common shared volume available, so I think I will have to set up a scripting system that 'walks' through the records in each table on the robot and creates a new record in the users local file.

Can anyone suggest another approach that might be more efficient and easier to implement, especially if I have to add new tables and fields to the robots files.

Thanks

Brian

Solved the problem by importing directly from the hosted file, rather than from a local export.

:P