Hello...need some help with the best way to design this database...here's what it consists of:
I have 3 main sections(1,2,3), and 4 subsections (A,B,C,D) under each of those main sections. The 4 subsections are the same for each main section.
I need to track inspections. Each subsection contains about 10 inspections; inspecting various elements such as safety, training, etc.
What is the best way to set up my tables and forms to differentiate between the sections and subsections, for reporting purposes?
I need to run reports based on 'upcoming', 'overdue', and 'date completed'
Currently I have a main page that lists the Subsections with a dropdown next to them to select which checklist/form to open. In the form the user selects their Main section and fills out all other subsequent data.
That format seems ok, but I am having issues running those reports.
In the reports section, I have them select a Main section and a Subsection from two dropdowns.
In the query I use 'Like "*" & [Forms]![frmMain]![Combo57]& "*" ' to filter the report to the dropdown of the Main section. I have tried various options in the 'Next Due' and 'Date Completed' fields to try and filter for what I need, but it always just pulls everything from the table.
Hopefully I explained that well enough. Thanks for the help!