Hi Jason,
My child recordset now looks like this (I have a session variable in there too):
SELECT veterinary_surgeon_table.branch_number, veterinary_surgeon_table.surgery_date, CONCAT(veterinary_surgeon_table.branch_number, veterinary_surgeon_table.surgery_date) as childID FROM veterinary_surgeon_table WHERE practice_id = %s GROUP BY veterinary_surgeon_table.surgery_date ORDER BY surgery_date ASC
But now for one surgery it returns no date and the other only 1 date, 21st March 2010. There is definitely more data in the database, can you see where I am going wrong.