We have a schema defined to 4 levels (example- ACCESSORIES>ACC_DEALER>AD_COMP_SALE>ADCS_FULL). However, some levels only go down 3 levels (example ACCESSORIES>ACC_INST_INFO> only goes down one more level, and not 2 more levels).
Is it possible to make levels manditory entry. How would this be done?
One option that we do not want to use is to create a dummy 4th level for those that do not have a 4th level.