Hello,

I have an excel spreadsheet that queries a FM database and it would be very useful if I could have it only query records that are part of the found set. If I could tag the records that are in the current set it would be easy.

So, is it possible to create a calculation that will = 1 if the record is a member of the current found set and 0 otherwise? It seems like a status function would be a great way to do this, but there isn't one for this purpose, at least as far as I can tell.

So is there a calculation for this? If not, any other strategies for doing what I'd like to do? Will I have to resort to a script?

Thanks,

Dan

What about Status(CurrentRecordNumber)? What does that return if the record isn't part of the current found set? And how the heck would you test such a thing anyway, being that you couldn't see the result if the record were not present?

That's not a bad idea. But it turns out that it doesn't work. At least I can't get it to. You can select which cases to query in Excel based on a field value. So, I thought that I'd only import if CurrentRecordNumber is >1 or IsNotNull, or semething to that effect. But to find out if CurrentRecordNumber is Null, Excel has to look at the record, and in so doing, makes it part of the found set, giving it a record number, and hence defeating the whole purpose. You end up with all of the records, and the FM database is reset to Show All Records.

But I've gotten to to work with a script, so if I can't do it with a calculation, it isn't the end of the world.

Thanks,

Dan