I've been trying for hours and can't seem to get it.

I have a Student Records database with 8 fields and a photo for each record.
I want to be able to send all data from an individual record to another file
named Orders.

I have been able to select the record that I want to use, open a new file in
Orders, and paste the first field data from Student Records.

That is as far as I have gotten. I've tried to have the script go to the
Student Record file, copy the next field, go to Orders and paste the field,
but it still pastes the original field contents.

Any help would be greatly appreciated.

Kenny the newby.

KennyS wrote:

NOTE: Answer assumes FM7, lacking any indication otherwise.

First and Foremost, a Terminology check: you can export from FM to a
variety of formats, as well as to another FM file, but not an existing one
(an export operation will overwrite an existing file). What you are
wanting to do is IMPORT INTO the Orders file, not EXPORT FROM the Student
Records file.

Find the records you want in Student Records. Leave the file open (see
note below).

Open Orders.

From the File Menu, select Import Records/File, and navigate as necessary
to find and select the Student Records file). You will be presented with a
mapping dialog. If the field names are, by any wild chance, the same in
both files, select "Matching Field Names." Otherwise, click and drag to
match source fields with destination fields.

Select whatever other options are appropriate (likely "Add New Records").

Click "Import".

I think you'll agree, it sure beats a one by one copy/paste marathon.

Another note: In FM7, you import a found set from an already open source
file. If the source file is not open, you get ALL records, not just the
found set.

Matt

THANKS! It worked... as I'm sure you knew it would.
Kenny


"Matt Wills" <I'm (AT) Witz (DOT) end> wrote

KennyS wrote:

Yup, that I did.

Your next trick will be to script the process, should you find you have to
do it repeatedly.

Matt