I have a FM app that has a button which will delete a record. However, instead of deleting this record I want to be able to push this record to a new db and delete the record from the original file.....

specifically... I have a scheduling app with a delivery schedule which lists due date and time. Once the job is delivered the user "deletes" the job from the db to keep the size down... I want to be to track on-time deliveries so I created another database with additional fields such as "actual delivery date.

Is there a way to add a script step that will "export" the data one record at a time to the new file.. I was thinking of creating a global calc to "paste" into... just not sure if this correct..

any thoughts

Step 1: Open the other file and import records from the first file (you'll probably want to delete them after finishing this step; fortunately, they'll be the current found set, so it's easy). Now create a script that imports records from the first file without dialog.

Step 2: Create a script in the first file:

Show all

Omit record

Show ommitted

Perform script [External script] -- and choose the import script from the other file

Delete record

That's it!

BTW, a word usage note: The files aren't "apps" -- Filemaker Pro is an app (or application). They're files, or databases, or tables, or solutions, or ... oh, I don't know, widgets maybe? ("You can call me Ray...")