>>In the currently selected work area, is it possible to reference fields in a record that is not the currently selected record?
>You may open the same table twice (USE mytable AGAIN ALIAS mytable1) move pointers to different records and compare.
That's what I thought you were gonna say. The other obvious way is to use an array and then achieve the desired result with subscript arithmetic.
It seems kind of weird that one can only reference the current record in the current work area (though I can understand the underlying disk file management issues that are being avoided by only allowing references to the active record within any one work area).
Still, I had to ask. I wanted to be sure there wasn't some mechanism I missed before doing it in a more complicated way.
"The Iron Fish: The water is cold...but the fish don't mind"
...Jay Jenks, boyhood chum