Hello All
so i messed up a table i had an records i enter even thou its the same can hav different client ids

so i wrote this query

SELECT COUNT(otest.fname) AS numrec,otest.fname,;
    otest.prefix,otest.bday,otest.aoonumber,;
   otest.id;
     FROM MAINBASE!OTEST;
GROUP BY otest.fname;
HAVING (numrec) >(1);
INTO TABLE dup

so that works fine it opens a dup table an i see like

Numrec   fname
2                   peter
3                      james

but im trying to link the otest table an the dup table in such a way that instead of showing one row for Peter an moving to JAmes it will show me the two rows for peter and the three for james so i can do what i need to do with them. Im fully aware i can just go in the Db an manually do it but.dont really wanna do that way. Thanks