Referential Integrity?

[Heids2265]

I have a foreclosure database. I have a foreclosure table and it had a
relationship to a bankruptcy table. I wanted to change the relationship to
B_Judges instead of B_District field in the bankruptcy table. I was
successful but now I am unable to select Referential Integrity because of
something in the Primary table. What's wrong?

 

[Al Campagna]

Heids2265,
You probably have some records in one, or both the tables that won't
allow for referential integrity.
Start by setting up query using the Bankrupt table related to your
Foreclose table using a Left Outer Join on B_Judges.
Use the B_Judge field from Bankrupt and the B_Judge from Foreclose
(Show all records in Bankrupt and only those in ForeClose that
match)
Any record in Foreclose with a blank B_Judge violates the integrity.

Now do just the opposite. Query ForeClose to Bankrupt, and see if you
get Bankrupt blank B_Judge records. Those too violtae integrity.

--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Heids2265]

To fix my problem I need to create a "temp entry" field so that the field
will always be filled in even without having to pick a specific judge.

Thank you very much for your help.

 

[Al Campagna]

I haven't no idea what you mean by that...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."