Referential integrity problem

[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?!

 

[Jason Lepack]

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

 

[Steve]

Go to the funding table and select FundingSourceID. In the bottom of the
table design delete the "0" for Default Value.

Steve