Foreign Key and Not Null

Hi

Just a basic question.  You can't have a foreign key on an item that is not null.  Is this correct?

Greg
greg_cAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
?
no, that is not correct.

you can have a foreign key pointing from and pointing to a field that is not null.
however, you will need to have the referred value in the "master/lookup" table be present BEFORE you use that value in the child table.
0
 
greg_cAuthor Commented:
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.