• 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

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 13 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 Raphael Pacheco 4.9k points
0 votes
1 answer 25 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 maddi86 5.4k points
0 votes
1 answer 146 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
2 answers 181 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