September 5, 200619 yr 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.
September 6, 200619 yr 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.
September 7, 200619 yr Author 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.
Create an account or sign in to comment