Hey everyone !
I’m working on house inspection App. The App has a built hierarchy in it. Meaning I have 5 residential compounds, each has several building in it, in each building there are 3 categories (private property, public property and exterior property). Each category has up to 25 “places” (a “place” could be an apartment if the category is private, or the rooftop if it’s exterior).
Basically it’s sums up to:
Compound name ------------------ Building name ------------------ Category name ------------------ Apartment #/“Place” #
Now the main idea of the App is creating inspection reports. Since I’ve linked all the tables above (Compounds, Building, etc…) with Ref to each other, one can create a report in each stage (each view within the app) of the hierarchy.
Since the report has to contain each of the 4 hierarchy stages,
one must note the missing stages when creating a report. (meaning that if you add a report while in the private category, you will only need to note the Apartment number)
Now when I’m adding a report in “Apartment #/“Place” #” view ,
it only adds automatically the Apartment number,
and the other
hierarchy stages need to note manually, which is time consuming when creating an entry.
I’ve tried to create dependent dropdowns but it didn’t worked.
Any Suggestions ?