3 Replies Latest reply on Nov 10, 2009 4:54 AM by david_lalonde@d-cogit.ca

    Value list requiring values where parent_id = 0

    danherbert

      Title

      Value list requiring values where parent_id = 0

      Post

      I want to choose values from a value list where the parent_id = 0

       

      The table has the following fields:

       

      cat_id

      category name

      parent_id

       

      where if parent_id = 0 the category is the parent category

       

      I want to use this to create a record in a product_category table and also be able to select any child category

       

      For example:

       

      cat_id category_name parent_id

      1        Pro AV             0

      2        Mics                1

       

      I dont know how to do this though!