473,322 Members | 1,405 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Subform linked to 2 separate tables

1
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.
Jul 12 '16 #1
1 739
PhilOfWalton
1,430 Expert 1GB
Not sure your table structure is correct. I can't see why you have a relationship between TblReports & TblItems.

Please provide further details.

I suspect that what you want is a form showing your main report, on i8t a subform showing categories and a second subform linked to the Categories subform. That is no problem, but need to see those tables first

Phil
Jul 12 '16 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used...
3
by: Scotty | last post by:
I have a database which is made up of several tables "contacts", "coaching", "clubs" etc. The Contact and coach tables are linked by an "ID" field. The Contact and clubs table are linked a by a...
1
by: shree | last post by:
I have connected MS Access to MySQL 5.0.17 with MyODBC 3.51.12 with MS Jet SP 8. It is giving error -7776 (There is no message for this error) while jumping from a form to a subform having two...
4
by: Markus Ernst | last post by:
Hi Looking for a possibility to get separate tables rendered with common column widths, I was surprised to see that this code validates: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"...
0
by: Pasquale | last post by:
I have a form with 8 fields, 4 of which are required and 4 are not. Usually if a field isn't required I would create a separate table for it rather than having a blank value in the table where...
0
by: data monkey | last post by:
My company's web application uses mySQL databases. I have linked these tables (Read only) into Access 2007 so I can create queries and reports. Now I need to extract some of the content from these...
2
by: dbstrat | last post by:
Hi. I have 3 tables that I need to display on a master-child form/subform. Think of it as Orders and Order Details. The tables are Orders OrderDetails VendorItems
1
by: krizzie khonnie | last post by:
Hi, Can anyone help me? What query should I use if my objective is to check if a record exists in either of the two separate tables.They have the same column name. Ex. Column Name -...
1
by: matthewra | last post by:
I have table: tblProj Proj_ID Proj_Name I have table tblOrg Org_ID Org_Name I have table linkProjOrgtable which is to link 1 or more orgs to a project linkProjOrg_ID key)
6
by: Dave0291 | last post by:
Hey, I have a problem and I'm kind of new to Access. I'm trying to update a field on one table by multiplying two fields from two separate tables. Now the problem is that every time I try an...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.