I have a database setup like this :

Warehouses > Sections > Boxes. Boxes are located inside sections and sections are divisions of warehouses.

Considering that each section is linked to one warehouse only, is there a way when creating a new box and assigning it to a section to have the drop menu list only the sections of the warehouse selected for that box, like a "sections" sub-menu of the menu "warehouses" ?

Secondary question : is there a way in a "warehouse" report that have Zoho Creator list all the "sections" linked to that warehouse as well as under each "section" a list of all the boxes linked to that section in the database.

Many thanks for your help!