Referential integrity problem

  • Thread starter Thread starter C Tate
  • Start date Start date
C

C Tate

I have enforced referential integrity in my relationships. However, it seems
to cause a problem if I want to leave a field blank! One of my tables is
housing, another is funding (for those houses). Attached to the funding table
is another, fundingsourceID. Although the person should select where the
funding is coming from (ie, the fundingsourceID), he might not know this
instantly. Does this mean I shouldn't enforce RI. Or have I just got my
design wrong?!
 
housing:
house_id - PK

funding_sources:
source_id - PK

house_funding:
house_id
source_id

Don't let source_id default to 0, and set it to not reuquired.

Cheers,
Jason Lepack
 
Back
Top