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 dupso that works fine it opens a dup table an i see like
Numrec fname 2 peter 3 jamesbut 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