export single record

[mireille]

Hello,

Is there a simple way to export a single record from one FM file to another already existing FM file?

Mireille

[andygaunt]

The best way is to write a script (or two scripts).

First, find an individual record in the database you want to export from.

Now, go to the database you want to import into and choose file > impot records. Select the first file and choose the fields to import.

Once done, you should have that record in the second database. OK, delete that record.

Now go to scripts > scriptmaker and write a script called import individual record.

Clear all and then choose Import records.

Check all the options including the specify file as the first database.

Click OK then done.

Now, go back to your first database and write a script called export current record.

Again clear all. Then add the following.

Show All Records

Omit Record

Show Omitted.

Perform Script [external, and choose the database that you wrote the import script in and select that script]

There you go. Job is done.

All you have to do now is assign a button to run that script.

You didn't say you wanted to delete the orginal record so have not done that.

HTH

[mireille]

thank you andy, it works!

mireille

[Mark Jones]

Thanks for the tip! That is exactly what I was looking for.

I love FMforums! You all are the best!

Mark Jones