archiving records

[john9210]

I would like to create a script to import records into an archive file (a duplicate of a source file). The source file has 3 or 4 tables of related records. I can create a source file script that sets up the records to be exported, but I'm not sure how to write the destination file script. I don't know, for example, how to get back to the source file and switch to the layouts that have the related records.

Any help would be appreciated.

[Keith LaMarre]

here's one way - in the source - you "find" the records you want in Table 1 (you don't really need to export - then go to the archive and import from Table 1

then go back and find the records you want in table 2 (or go to the related records - then go to the target and import - then continue like that for all related tables.

Are you using FM Pro Server? - are you deleting the records from the original source - because it you are not, you can setup some schedules to backup - or archive.

[john9210]

Thanks for the response, it helped a lot. I also found that opening and studying the import dialog box explained everything. I'm surprised I couldn't find a better explanation in the FM "help" file.