Writing data to another file

[keithstone]

I want to write data from a record out to another file before the record is updated so that I can track the update history of the record. I can't seem to find a way to do that in FileMaker. In SQL databases like SQL Server, it's easy: just an INSERT TABLE statement. In FileMaker, it looks like the best I can hope for is to write out the single record to an exported file, then at some point, import the record into the "history" file.

Maybe there's a more straightforward way to do this?

[Kericomp]

The only method I have found is as you suggest

- export data from file1

- run a script in file2 that imports the data

It's the easiest method and doesn't involve to much processing.