AnsweredAssumed Answered

Value list requiring values where parent_id = 0

Question asked by danherbert on Nov 10, 2009
Latest reply on Nov 10, 2009 by david_lalonde@d-cogit.ca

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!

Outcomes