Hi everyone, sorry, this is a bit of a newb question but I appreciate your help greatly! If I see the opportunity to help others I will be sure to do so!

Anyways, I have a bit of a scriptmaker problem, and was wondering if anyone could help.

Basically, I have an interface that allows the user to enter certain find criteria in, and list the results. From there, I want to be able to go to another screen that constricts those found results in a certain way (basically, I am going to be showing only ones of a certain currency.) At present, I am just performing an additional find which I did in advance and placed in a script. However, when I am done constricting, I need to be able to return to my original found set (the set that the user entered in) and then constrict in a different way.

I don't know how to do this, does anybody have any good ideas? Thanks a lot!

Jim

One of my first fields to be defned is Marker. This is a text field which might or might not hold an 'X'.

Two scripts - Clear Marker and Set Marker.

Clear Marker

Show All Records

Replace (No dialogue, Marker, "")

Set Marker

Replace (No dialogue, Marker "X")

I usually Clear Marker at open time - but not always, depends on the DB.

If you're in a multi-user situation, this is not a good idea. More than one person can be modifying the same field. And if someone else is currently modifying one of the records, a Replace will fail.

It would probably be a better idea to use the Copy All Records trick. Create a layout that contains only the id for each record. Also, create a global text field and a relationship from this global to the record id field. To save the found set, go to the layout containing only the id, Copy All Records, go to a layout containing the global, and Paste.

Now, when you want to return to that found set, just Go to Related Record [show, self|global_id].

Thank you INCREDIBLY...

That worked like magic! I really appreciate also that you noted that it might not be multi user safe (Although still thank you Paul for posting!) because in this instance, the file system will be used by multiple users at the same time. Again, thank you all very much, I am much obliged!

Jim

Ooops! I always ignore other people.

Thanks for the reminder.