Jump to content

copy and remove complete record from one file to another


This topic is 8512 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 smile.gif. 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

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

Link to comment
Share on other sites

This topic is 8512 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.