>I can not imagine anyone using a recno as a key, but I guess it could be done.
>
>There are frequently reasons to know how many records are in a file and what records you are loking at. It is not a great and wonderful fearture, just imformative. The current application is just a simple mailing list for a geneology group. I want to recno() of Reccount() which is also the total count for members who have paid for a small newsletter we publish.
>
It's a particularly useless number when you have an index in effect; the physical record number is not likely to match up with the logical record number; if you have a file with 500 records, with the first record having the name 'zygote' and the last record having the name 'aardvark', and you have it indexed on name, the record named 'zygote' will appear at or near the end of the list, and 'aardvark' near the beginning, but they'll keep their physical record number. People who try doing things based on RECNO() (for example, some people try to use RECNO() as the basis for alternating background line color in a grid) are usually pretty miffed at the result, since there's no guarentee that an even numbered record will be bounded by two odd record numbers. If you ave a filter in effect, so that only 10 of the 500 records are valid for processing/viewing, the RECNO() values stay the same. If you delete records, the record numbers stay the same - until you pack the file and remove dead records, and all records get renumbered.
>So yes it is not a vital number, just interesting.
>
>I have much to learn with regards to VFP and I do appreciate the help!
>
>THANKS