record control issue

[bckwheat]

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

[slstrother]

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"]

[bckwheat]

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

Thank you ever so much.

buckwheat says "Otay"

[bckwheat]

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?

[jasonwood]

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

[bckwheat]

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.

[bckwheat]

thanks I got it to work.