copy and remove complete record from one file to another

[raif]

HI, I have a task schedule set up. When a task is completed I would like to send the complete record to an other fm file like completed orders.fm5 and remove it from the schedule file so as to not clutter things up. I have set up a script which exports to a temp file and and a completed order file which imports form that file but it is mighty cumbersome and also can crash fm. I am open to any options your help is appreaciated.

Raif

[danjacoby]

Let's call the two files Source and Destination.

First, open Destination and perform an import from Source. Then create a script (called Import) which performs the import.

Now open Source and create the following script:

Show All

Omit record

Show Omitted

Perform script (External: Destination/Import)

Delete record

et voila.

[danjacoby]

Let's call the two files Source and Destination.

First, open Destination and perform an import from Source. Then create a script (called Import) which performs the import.

Now open Source and create a script with the following steps:

Show All

Omit record

Show Omitted

Perform script (External: Destination/Import)

Delete record

et voila.

[raif]

Thanks Dan,

That Certainly seems to do the job. I knew there was a better way. However, I don't claim to understand the logic of how it worked. And that may be why I'm having more problems . I have info in the source file that is in a portal from another file, source two. which I now need to export to dest. two. so that destination one can reference it but source one can't. Perhaps you could expain the logic here and I could figure it out or you could just tell me the fix. Either one would be very much appreaciated

Thanks

Raif

------------------