>>I can't seem to get started with the program code to loop through (top to bottom) the records in a table. Can someone help?
>
>SCAN
>...
>ENDSCAN
>are one option; another is
>DO WHILE .NOT. EOF()
>
>ENDDO
>
>SCAN is preferred since it can be rushmore optimized and auto-skips to the next record.

There is also the old For loop...
GO TOP
FOR i = 1 to RECCOUNT()
...
SKIP 1
ENDFOR

For is supposed to be faster than While but slower than Scan, but each one of these types of loops is most appropriate for different situations...