>Josh,
>Thanks for the reply. What I was trying to do was get the last entry for a particular customer. Creating the index on ACCT DESC in Fox2.5 did this but in VFP if gets the FIRST entry for the Customer even though ACCT are listed in descending order in the table. It seems to me that to constuct the index in this manner must mean extra work on VFP's part so there must be some sort of reason for it - which I can't figure out.
No, it means that when traversing the index; it arrives at the node for identical keys and runs through the children of that node in the fastest possible order of traversal, which may not be processing from the last leaf of node to the first; in fact, forward tranversal through a list of equals is almost certain to be faster if equivalent keys are grouped together as a singly-linked list.