add:
GROUP BY veterinary_surgeon_table.surgery_date
to the child recordset
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
GROUP BY veterinary_surgeon_table.surgery_date