November 17, 200223 yr Newbies 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?
November 18, 200223 yr Newbies 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.
Create an account or sign in to comment