Jump to content
Sign in to follow this  
jim0203

How much does Filemaker remember about found sets?

Recommended Posts

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!

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.