I am making a check list app where each customer has many sites, each site has many areas, each area has many pieces of equipment and each piece of equipment has a single basic equipment type. Each basic equipment type can have many stock check list items. And each stock checklist item can have as many possible selection options as you want when setting up the stock checklist item. In addition, I have set up the app such that a “notes” field is hidden until one specific option is selected.
Everything is accomplished by way of parent-child tables with the exception of the stock check list items. The possible selection options are entered as an enum list.
This allows me to set up the detail view for each “related checklist item” to allow quick edit for the selection and it allows me to show the possible selections as buttons and not a drop down. Which I think is pretty slick.
I find that the parent-child-grandchild-great grandchild… nth grandchild navigation is very cumbersome though.
I am currently looking for some way to come up with a view that could be comprised of some scrolling list of “detail views” for only the items related to the current row of the parent record…
I am aware of the side show mode but that just doesn’t quite work for my application. I would really like to see all related records on the same page which can be scrolled vertically.
Please keep in mind that I have designed this app to be very robust and that creating a separate checklist table is not within the realm of possibilities…