LOL, I'll have to look into that Doh! I guess I'm still doing things the old way.
I'm manually creating my JOIN in my recordset.
SELECT clients.consultant_id, clients.client_rec_id, consultants.consultant_rec_id, consultants.fname, consultants.lname
FROM clients JOIN consultants ON consultants.consultant_rec_id = clients.consultant_id
WHERE client_rec_id = colname
The colname Variable is defined to receive the rec_id from a GET ( $_GET['id'] )