I want to be able to export selected fields from the existing displayed record in one FM database to fields in a new record in another FM database.

Everything I have tried exports the selected fields of all the records.

Is it possible to do this with a FM script and/or AppleScript?

Can anybody point me in the right direction?

You can do ti with an FM script, using "go to field" and "set field" script steps

I think you want to import from FileMaker file to another rather than export. If you export, you'll make the process two steps instead of one. A simple FileMaker script will do the job. Just use the Import Records script step. It will remember the fields and the source table.

However, you may need to isolate a single record in your source table since it sounds like you only want to import a single record (this may be the root of your question). You can do that with the following script steps:

Show All Records

Omit Record

Show Omitted Only

FileMaker imports the found set of records from the source table so isolating the record you want will make a found set of just your record. BTW, if the file is NOT open, FileMaker will import all of the records regardless of the found set.