>Oh is there a way i can number records? as in if a all records get a value of one an if it is encountered again it gets incremented an gets 2 and if i see it a thrid time it gets 3 etc?so example
>we have three instances of peter
>the first one will be
>
>1 peter
>2 peter
>3 peter
>
If your original table doesn't have an ID field (or fields combinations making a unique key), then in VFP the only way would be to rely on recno()
I already posted this version in my previous replies.
If you want to add this to the select, then
select Name, cast(0 as I) as IDField from myTable group by Name having count(*) > 1 into cursor csrDups readwrite
replace all IDField with recno() in csrDups
If it's not broken, fix it until it is.
My Blog