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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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