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?