Hilmar sent me this solution for tracking duplicates in a database a little while ago - it works very well.
Further to this solution, how would i display the names plus an added field called field2 and attribute this information to a variable called myinfo.
Thanks for your help.
k
select name, count(*) as count;
from mydata;
group by name;
having count > 1;
INTO CURSOR TEMPDUPLICATE
if _tally > 0
MessageBox("Alert: There are duplicates.")
browse normal
endif