Did you ever have an application where you need the values in the previous record. Say for instance the input screen is for today's data but you want to show yesterday's data.

Do the following:

use Myfile in 0
use Myfile again in 0 alias ystrday order mydatefield

select Myfile
set relation to (mydatefield-1) into ystrday

Just though I would pass this idea along.