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
João serras-pereiraAsked:
Who is Participating?
 
FlysterConnect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.