Is there a way in MS Access (2013) to link a subform to 2 separate parent forms? Basically I am trying to create a database for another team who want to create many different compliance reports. Each report has 14 separate categories and these categories are always the same for every report. Each category will have different items in for each report. Subsequently each item will have many findings, and each finding will have many recommended actions.
The links from items to findings to recommended actions are fine, I know I can just link the subforms to each parent form.
Where I am struggling is linking the items to both the reports and categories tables in a form. The relationships for the tables are one to many for both. So, I have tblReports and tblCategories as master tables both linking in to tblItems. When I create a form and try to filter the items by comboboxes, I can only link to one parent form and not both. I have tried creating queries, creating an extra table but always run into an issue and it doesn't work, if anyone has any suggestions they would be greatly appreciated.