I am writing a script which examines a found set of records in one table and, based on the content of each record, creates a record in a different table.

What I want to know is, if I switch from one layout to another and then switch back, does Filemaker remember which found set I'd been working on in the first layout, and the record I had selected?

The pseudo-script goes something like this:

Go to Layout A

[Get to a found set]

Go to record 1

Loop

  Set all fields from record 1 to variables

  Go to Layout B

  New record

  [Create new record based on variables set in step 4]

  Go to Layout A

  Go to next record (exit after last)

End Loop

It seems to work, I just want to be sure!

Hi Jim, and Welcome to the Forum.

It is usually not necessary to duplicate data, and if you have found it necessary, then you need to reconsider your options.

You need to go into more detail on why you need to duplicate this data. i.e. what is the data, why do you need to duplicate it, etc.

Lee

It is necessary in this instance - I think - as I need to keep one copy of the data fixed as a backup. The other one might can be changed.

Will my script do the job? I've not found any problems when testing but I'm not entirely sure.

Your script will work fine, as far as I can see. Importing the data would be much simpler, I think.