-1

I am trying to add a foreign relationship between two tables. When I add the FK column to my table and leave the check box for Allow Nulls blank, it wont let me save. Explaining the column does not allow nulls. How to get around this?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
EB.
  • 2,627
  • 8
  • 35
  • 55

1 Answers1

0

Solved. The Table had data in it. 

Delete from MyTable

Then I was allowed Not Null. Table Saved.

EB.
  • 2,627
  • 8
  • 35
  • 55