hi jimmy,
i cant run this through mysql direct as the sesion variables etc are php variables generated by data assist.
they are the ones that come were generated from the details page so i copied them and tried with this recordset.
can you help with the recordset so it shows that product status for that clientid?
many thanks