I'm thinking to create 3 levels of categories for a store
Level 1 : 2 Characters (es. 11)
Level 2 : 2 Characters (es. 1122)
Level 3 : 4 Characters (es. 11223333)
sample :
cCodice:= 01020001
cDesc := Italian keyboard black
I have some problems to build valid at get when the user insert a new record because the valid function must to control if there is the higher-level of the code he inserted
Isample : if the user insert the code := 01020001
he must insert before 01 keyboard, 0102 Italian Keyboard and then he can insert the new category
Any help please to build the valid function