Validate Relationship

[gaelin]

Is there a way to setup a relationship/contraint to validate
if the foreign key data matches a prime key in another table--where the field to be validated may contain nulls?

The field (fkeydoc) is filled if funding is added or subtracted to the table (audit table). When payments occur the field is left null. Hence the field will read:

471
472
null
581
688

 

[JohnDTampaBay]

FOREIGN KEY constraint on FKeyDoc referencing the audit should do the trick. The constraint does not validate NULL against the referenced table, only actual values.

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[gaelin]

Using SQL Server 2000, hence not allowed to use a select statement in a constraint.