IT WORKED! you>all
well that was easier than what we did yesterday :P
>>

>>
>>Select zero
>>pnRec=0
>>pcname=zero.fname
>>set order to fName
>>Scan while not eof() && to make sure we're using our order (it's not really necessary)
>>         IF pcname=zero.fname
>>                     pnRec=m.pnrec+1
>>           Else 
>>                pnRec=1
>                  pcName = zero.fName
>>           Endif
>>         Replace IDfield with pnRec
>>Endscan
>>

>>
>>but looking at it,im not seeing where pcname is being incremented unless the scan will do it
>
>I made two corrections in the code above, but yes, that's exactly right.