what would be the best way to copy a record to another db. I tried importing but cannot get it to work. Is there another way i can do this, so i can go to that db to look up my messages. thanks, jim

"Best" way depends on the situation, but a good way is to use a constant relationship and global fields. For the relationship, you need a calc field in each file that = 1. Make a relation and call it "One." Then create global fields that correspond to each field you want to copy. Your script would then look something like:

Set Field [gName, name]

Perform script [external, otherdb]

In the other db, the script that's called would do the reverse:

Set Field [name, One::gName]

Hi Jim,

You didn't say if this was from one FileMaker file to another FileMaker file, however by the way it reads, it appears that that is the situation.

IMHO, importing this way is the easiest way to move data between FileMaker files when the information needs to be in that file and not just seen as in a portal.

It does take a little preparation though, depending on how the field names match up. If the names are the same or similar, what is the problem?

If the names are way different, then you might have to manually go through both files (you can print the fields descriptions) and match up what fields are going to be imported into which fields.

If you are going to be importing from the same file more than once, it is probably worth the effort to write a script, once you have the import working the way you want.

HTH

Lee

Couldn't one just create a new record in the other database via a portal relationship. ie:

Go to Portal Row Last

Set Fields (various, which don't need to be in the portal)

Delete Record

Pete