[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 332
  • 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

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

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