MS Access 2010
Intermediate level of knowledge. Not a beginner, but not an expert.
VERY limited knowledge of SQL (assume none).
I'm developing a database to track all the types of items (issues) on a project. There are several different documents that will be printed - Weekly Status, To Do List, Monthly Status, etc.
Each issue can appear on multiple documents ("reports").
Each document ("report") can show multiple issues.
It's a many-to-many relationship. See image attached for the relationships diagram.
tblItems: Has all issues and pertinent information related to the issues (who it's assigned to, when it was initiated, due date, etc). ItemID - unique identifier.
tblReportType: Has the types of documents that will include each issue. ReportTypeID - unique identifier.
tblReportDates: Each Week can have multiple reports created that week. ReportDatesID - unique identifier.
tblReports_Items: the junction table that contains ItemID, ReportDatesID.
I'm trying to develop a data entry form that does the following:
1. In the main form (based on tblReportDates): The user will select a ReportTypeID, a StartDateRange, a FinishDateRange.
2. In the subform (based on....a query, I presume): The user will enter all the information about this Issue.
3. The ReportDatesID from tblReportDates will be saved into the junction table tblReports_Items.
4. The ItemID from tblAllItems will be saved into the junction table tblReports_Items.
HOW???
I've researched YouTube for a tutorial video and couldn't find anything relevant to my particular question. I'd appreciate any pointers on where to go check a solution for this problem.
Thank you in advance,
Varda