how to set distinct on childlist
I have 2 tables setup. Counties (parent) Business categories (child) All works as it should with the dynamic dropdowns except:
Currently the child recordset is set as;
SELECT bizID, bizCategory, cat_id FROM bizconns GROUP BY bizID
The problem I cannot seem to work out is how to set a distinct within the child recordset.
I'm losing my hair on this one!
Please if anyone can point me in the right direction, thanks.