Smart Ranges Implements as Find Requests

[Vaughan]

Folks

Smart Ranges allows you to generate relationships keys for ranges of dates and numbers without exceeding the 64KB limit, using only native FMP calculations.

It's way cool.

I've just taken the Smart Ranges keys and used them to generate find requests. This allows more complex finds and searches to be performed (though the demo file is only set up for one find request, it could be extended to more reasonably easily.)

It took me two whole days and half the night in-between to nut this one out. If you haven't read the Smart Ranges docs, do so before you open the hood on the demo.

SmartRangesFindRequests1.1.zip

[aaa]

I tried it. And it seems to mee that this works faster, than relatioship in version 7.Is this truly? Who tried?

[Vaughan]

It's not really meant to replace relationships or portals, but instead another application of the Smart Ranges technique. Smart ranges is still pretty cool IMHO.

The new improved relationships in FMP 7 may render Smart ranges a bit obsolete anyway.