Assign the 2nd drop down a value of 0 if it has no values
I have categories and some have sub categories others do not. If they do not I want the subcategory in the 2nd drop down to be assigned a value of 0.
I had no problem doing this on the insert page but the same method does not work on the update page and a value of null is being inserted instead of 0 and i has to be 0
Category
Book
Gifts
SubCategory
Book > Novel
Book > Reference