Thanks Ray... sorry but dont really understand
"Then you can use 0 as the parent for the main categories and the ID of the category for any sub categories."
Have copued the productcategories table and names it productsubcategories. Have added CategoryParentID to the new productsubcategories table but not sure what I need to do now...