I am interested in applying inheritance into Zoho Creator Database. Currently, we have four dropdown menus and we want there to be inheritance with the options inside each of the dropdowns. I was told I could do map field dependency on CRM but I only have the Creator. Here is an example of what we would be looking for:
User selects Discipline (Options: Architectural, Mechanical, Grounds, etc) "Architectural"
Next, the user selects Category (Options based on selection of Architectural: Exterior Shell, Interior Shell) "Exterior Shell"
Next, the user selects System (Options based on previous two: Features, Opening, etc) "Features"
Last, the user selects Subsystem (Options based on previous three: Painting, Porches, etc) "Painting"
So as you see, there are four dropdown menus and they each part of a large "map" of choices. Doing control statements would take a long time to do. Can someone please help me? thank you!