Recursive Function or Calculation

[William Lawrence]

Is there a function in filemaker that will allow the developer to tell if a record is currently a member of the found set? I know this sounds strange, but it's what were trying to do.

A little backgound:

We have a fairly large FM7 database. We are trying to add a "back" button to the solution to allow users to return to previous screens and found sets. The layouts are no problem, but we're trying to figure out a way to capture all of the entries of the key field for the found set. This can easily be done with a value list, but that returns ALL values, not just what's currently actvie. It can also be done with a loop into a global, or a replace into a field which can then use a value list of related records, but we're trying to avoid this due to speed reasons.

Do anyone know of a way to make a calc return a 1 if it's in the current found set, or 0 if not active/omitted?

And help would be appreciated!!

William Lawrence

[Fenton]

There is no way to use a calculation for this. Copy All Records into a global was the fastest way. But there is a new way in 7. It is rather mind-bending, so I'll let the originator explain it:

http://www.sumware.net/robfm/savingfoundsets.php

[comment]

It's a neat idea - but simply opening a new window can do the same, with no additional TO or layout required.

[Søren Dyhr]

It is rather mind-bending,

It really is! Unfortunately doesn't it help the clipboard jeopardizing needed for putting found sets in a portal in IWP to circumvent the upper limit for list-views previously 5 now 25 lines ....I had hoped for! But I'll definitely keep it in mind ...thanks for letting us know!

I know it's slightly piggybacking, but what clipboard is used when Copy All Records is issued in IWP ...how the h*** can it be multiuser safe???

--sd

[William Lawrence]

Thanks everyone for your input. I think we'll go with the old replace. We were just trying to think of something quicker.