It seems simple but . . . I can't get it to work

I have a very simple 6 field DB (DB1) that pulls data from a relationship DB (DB2). What I am trying to do is when the job is complete a date is put in the 6th field of DB1. Then the job is complete and I need to purge the record. Here's my dilema.

1. I need to find the "completed" jobs (no problem, I scripted it)

2. Sort (no problem, same script)

3. copy the "found and sorted" records ( no problem, same script)

4. Place in "found and sorted" records in a 3rd DB (history file for stat analysis) and then return control back to DB1 to delete "found and sorted records.

I realize that I could copy and then delete, but my issue is getting the records into a third database without using a manual import/export situation.

thanks for any input. It seems so simple, but my simple mind doesn't always prevail

Create an import script in DB3 and execute from DB1 using the Perform Script step. FM will only import records in the found set of the source FM db. Add a Go to Layout step to return to DB1.

Perform Script[sub-scripts,external:"DB3.fp5","import"]

Go to Layout["Your Layout"]

Sometimes the obvious is just TOO easy. A Mind f*rt on my part.

Thank you ever so much.

buckwheat says "Otay"

thanks for the help on the external routine. If you don't mind steering me again, I have one for you.

I have a field (f1), that has a pop up menu that includes "low, out. completed". I also have another field in the same record that is date completed (f2). I would like to use the pop up menu to select "completed" in f1 and it auto enter in f2 the current system date.

Any ideas?

Might be easier to have a "Completed" button that does both (changes the popup and sets the date).

I tried that but I can't get the system date to auto enter from a button. I have beaten the filemaker pro bible to death trying to get it to work.

thanks I got it to work.