• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

ms/access 2013 enforce referencial integrity

I ha a small database of sales people that are distributed over a country. It is a strongly hierarchical model (I am attaching the database) with a bottom table (T21) with people.

The situation is that I am consistently getting an error (violation of referential integrity), when I try to setup the final relationships with all sales people. But, no matter how, I cannot find the violating records.

I have generated a bunch of queries to try to detect them (the Q90 series), trying to find record on T21 that cannot be matched on T15, and I am pretty sure that they are there, but the queries cannot find them. can anyone help?
FollowUpDB-06.zip
screenshot.docx
0
João serras-pereira
Asked:
João serras-pereira
1 Solution
 
FlysterCommented:
You are getting that error because in table T_15_Comissoes, all the values in the NumInternoDelegado field are 0. There is no 0 in table T_20_Delegado for that field.

Flyster
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now