BACKGROUND
This is a database for the management of a private family cabin that is owned and used by a dispersed second generation.
- Everything is organized into a three-layer hierarchy of locations: (1) Sections > (2) Areas > (3) Sub-Areas (defined as three tables with PK/FK relations established).
- Any location, at any of the three levels, can have two main types of data:
(A) Orientation/Summary Information (a text field in each of the three Location tables), and
(B) checklist items for procedures occurring at four main stages each year (defined in the "TYPEINFO" table):
(1) Season Opening,
(2) Mid-Season Departure,
(3) Mid-Season Arrival, and
(4) Season Closing. - These check list items are all stored in a single (poorly named) "INFO" table with foreign key/s to the associated location and a field for TYPEINFO.
QUESTION Database: https://www.dropbox.com/transfer/AAAAAH ... 9RIciEdKMA
I've created a form (with several linked subforms) for reviewing and editing the Location, Orientation, and Checklist data ("Main Form 3"). This form works fine, but it is unwieldy to have three identical report sections for the exact same data points (Orientation field and four stages of checklist items) -- one for each of the three Location levels (Section>Area>Subarea). Not every Location has these data and so the user sees a lot of blank fields and has to scroll up and down the form to find the relevant info. I would prefer to keep this all on the same main form rather than having to open a new form window for Location details.
Can you help me show the Location "details" (i.e., the Orientation field and four Staged Checklists subforms) in the same place, regardless of which location level is the focus? So far I have been able to avoid using any macros, thankfully, but I presume this would involve three "Detail" buttons (one for each of the Location table-controls) to show the selected Location's Orientation field and the four Staged Checklist subforms) in the same spot, whether it's a Section, Area, or Subarea.
Would "power filtering" be a better approach rather than using the three Location subform table controls?
Thank you for your assistance.