Copy and paste help

[cterrell16]

How can you run a script to copy the contents of one field, then open another database, perform a find where it would paste the copied contents to one field.

I'm trying to use

Copy [select; work order:::Order#]

Open file [invoicing]

Perform find ?

Paste [here's where I have the problem]

[bcooney]

You don't. You relate the files by OrderID and use Go To Related Record.

[comment]

It would also be better to have the tables in the same file, I think.

[cterrell16]

I tried to use the relate function but I'm trying to relate from a portal that is linked to two different databases. Is there not a way to do what I want with copy and paste.

I've got it copying the numbers but I can not get it to find, paste into the spot and perform the find.

[bruceR]

Copy and paste should be avoided in scripting. You will be much better off in the long run learning about relationships and proper scripting.

There is no "relate function". There can be a relation in one file that points to data in another file.

Any chance you can post your files or clones of your files?

[cterrell16]

I would but my server has the items locked where I can't copy them.

There has to be a simple way.

[bruceR]

There is; it was provided in the first reply.

You can also write a script in the second file that gets called by a script in the first file.

This is FileMaker Server? What version of server are you running? You should be able to copy from the backups folder.