How are Category and Subcategory related in Incident

[yvan]

I'm trying to write a transform map to import a large quantity of Categories and Subcategories for Incident, and I can't for the life of me figure out how one is related to the other, I see nothing like a parent field or the like.

[SanjivMeher]

If you open the dictionary of subcategory field, you will see the dependent field is set to category.

You can find the dependency mapping in sys_choice table. Element will hold the field name and table will hold the table  name.

Value holds the subcategory list and dependent value holds the category value

[SanjivMeher]

Please mark the answer closed if it is fine with you and close the thread