• Register
0 votes

Problem :

I am facing the below error :

“Microsoft access can't create this relationship and enforce referential integrity”

I have already checked everything for the errors: primary key, uniqueness, and type. But the Access is just unable to link the 2 fields which I have in my database. can someone please let me know the solution if any?

6 5 3
7,540 points

Please log in or register to answer this question.

1 Answer

0 votes

Solution :

Actually I think you need an index on your name fields, on both sides

But, I also want to suggest you that you are having way too many joins? Ideally there should be only one join from the one table to the other. It is very rare to have more than one join between the tables, and I can say exceedingly rare to have more than two joins.

Each of the fields labeled PK should be primary keys. These are generally AUTONUMBER fields. Each of the fields which are labeled FK are foreign keys. These are usually indexed Number fields of the type Integer. Your Primary Keys should be connected to your Foreign Keys in the 1 to many relationship.

Most of the times you will not need any other kind of joins. So the trick here is to create the tables with unique information. There should not be the repeated information in your database.The database that is reorganized in above manner is called as "normalized" database.

9 7 4
38,600 points

Related questions

0 votes
1 answer 26 views
Problem: Currently I have a shared access application. I have basic knowledge in VBA. I have created the accde file for a 32-bit machine but when user tries to open the application then he or she is getting a below security warning: “Microsoft office has identified a potential security concern.” I want to know the way to disable the above message from appearing to the users.
asked Aug 29, 2020 Raphael Pacheco 4.9k points
0 votes
1 answer 47 views
Problem: Can anyone guide me with the right solution as I am new and learning database? Which of the following does not violate the referential integrity of a database? Inserting a new row into a table with a foreign key that doesn't match a primary key in ... related rows in all related tables Deleting a row in a foreign key table without deleting the related row in the related primary key table
asked Feb 17, 2020 maddi86 5.4k points
0 votes
1 answer 224 views
Problem : I am having the following error whenever I am trying to open Excel Online in Chrome, But Excel Online in Safari is working fine for me. Does anyone know how to fix this issue? Sign in Something went wrong and we can't sign you in ... . Please try again later. The Microsoft account login server has detected too many repeated authentication attempts. Please wait a moment and try again.
asked Nov 26, 2019 alecxe 7.5k points
0 votes
1 answer 18 views
0 votes
2 answers 244 views
Problem : Facing following C# selenium webdriver error while reading Excel Sheet. missing compiler required member 'microsoft.csharp.runtimebinder.csharpargumentinfo.create' And the code for reading excel is as below: excel.Application x1Appl = new excel.Application(); excel. ... \o\SearchBy.xlsx"); excel._Worksheet x1WorkSheet = x1WorkBook.Sheets[1]; Kindly let me know is there anything missing?
asked Nov 18, 2019 peterlaw 6.9k points
0 votes
2 answers 275 views
Problem : I am trying to export from my Table data into Excel through T-SQL query but getting bellow error cannot create an instance of ole db provider "microsoft.ace.oledb.12.0" for linked server "(null)".
asked Nov 7, 2019 peterlaw 6.9k points
0 votes
1 answer 26 views
Problem: Microsoft charges a price of $599 for a copy of Windows 7. Is this pricing decision rational?
asked Apr 12, 2020 ArifulIslam 5.6k points
0 votes
1 answer 28 views
Problems: I am unaware about market, so can anyone guide me? Microsoft charges a price of​ $599 for a copy of Windows 7. Is this pricing decision​ rational?
asked Feb 13, 2020 maddi86 5.4k points
1 vote
1 answer 127 views
Problem : I am beginner to Arduino Uno. I have very recently installed the new IDE on my Laptop and suddenly I started facing below error if I tried to compile the program. I am using the Arduino Uno for the very first time. “Avrdude: ser_open(): can't open ... am trying very hard to fix above error from past couple of days but still unable to fix it. Please help me in fixing above error.
asked Mar 27, 2020 morrisBson 3.2k points
1 vote
3 answers 1.2K views
Problem : Currently I am using a Arduino API with the Uno board and it was working fine until few days. Recently I was working with the interrupt timers and somehow my board went into a mode where I am unable to upload the app. I have the app which blinks the LED light. ... ": Access is denied.” I have also tried to reboot my PC but still it is not working for me. How to fix above error?
asked Mar 27, 2020 morrisBson 3.2k points