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
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