JOHN DOE CHILDREN PET ---------- --------------------------- Bobby Fluffy Tommy Spot Sue Ann JIM SMITH CHILDREN PET ---------- --------------------------- Sam Fido Flipper LassieOf course any given person may have any number of pets or children or none or some of both or either (wow- that was mouthful). I'm playing with various joins to see if I can come up with something the report writer can deal with. Any ideas?