cindy.endris
Newbie
- Local time
- Today, 12:49
- Joined
- May 29, 2008
- Messages
- 20
Good Morning All,
I need YOUR help! I am trying to build a relationship (with referential integrity) between two tables but Access is not allowing me to. The message I received stated:
"Microsoft Office Access can't create the relationship and enforce referential integrity.
Data in the table 'tbl 401k' violates referential integrity rules. For example, there may be records relating to an employee in the related table, but no record for the employee in the primary table. ...."
I double checked the records and it matched perfectly. I even brought the data over to excel and use the EXACT function to reverify. I even try to use different join type and still receive the same message mentioned above.
What other rules are there in regards to Referential Integrity?
Any suggestions/comments will be greatly appreciated!
Cheers, Cindy E.
I need YOUR help! I am trying to build a relationship (with referential integrity) between two tables but Access is not allowing me to. The message I received stated:
"Microsoft Office Access can't create the relationship and enforce referential integrity.
Data in the table 'tbl 401k' violates referential integrity rules. For example, there may be records relating to an employee in the related table, but no record for the employee in the primary table. ...."
I double checked the records and it matched perfectly. I even brought the data over to excel and use the EXACT function to reverify. I even try to use different join type and still receive the same message mentioned above.
What other rules are there in regards to Referential Integrity?
Any suggestions/comments will be greatly appreciated!
Cheers, Cindy E.