Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

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
0
greg_c
Asked:
greg_c
1 Solution
 
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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now