Hi sorry I should have explained myself properly. I was referring to the displaying of the parent names as option groups inside the multi-select. because there could be lots of child-categories (from different parents) with the same names, this would get confusing, but by grouping the child categories to their parents, it would make it easier for the client to visually see what child category they are choosing. I guess the solution would be to do what you did for me the other night where you placed the recordset inside a while loop. The other method was to either do an alias or a AS mysql statement in the recordset. It would be nice to learn the AS sql version :)
Chris