I am setting up a database that is being used develop a Maintenance Schedule for various projects. Some specifics include:
- I have started by setting up the maintenance schedules for individual components (there are more than 50 components), and have created a report for each of the components.
- A Project will consist of several components (each component identified by a specific line item # within the project). I have set up a form to enter the Main Project Information, with a sub form (linked by Project_Number) to enter the Item_Number & select the Component from a Drop Down Box (see picture below).
- Once all of the components are entered for a project, I would like to be able to print the full Maintenance Schedule for the project including:
- A Maintenance Schedule for each Line Item entered
- The Project Information & Item_Number should be on the top of each Individual Schedule
- The same component can show up multiple times with a different Item_Number
- I am thinking that I will need to us sub-reports somehow, but am not sure how to make it work (the full Maintenance Schedule could have only one (1) component, or could have as over 30 components).
I would appreciate any help that can be provided, and if I need further information on what I am trying to do, just ask.
I am using Access 2010 (32 bit)