Allowing Null Values in Access

• Jacob Pressures

  SSCertifiable

  Points: 5804

  More actions

  December 28, 2004 at 7:45 am

  #65500

  I have a table with a FK in Response table that is PK in the Answers Table. I want to be able to insert Null values into the FK, because users don't necessarily have to answer a question. In design view i can place Is Null in the Validation Rules and it will allow me to put null values in. However, it will not allow me to put valid key values in any longer.  If i take Is Null out, it will allow me to put in valid key values. I want to know how i can do both--allow Key values and Null values.

  Thanks!

• Bob Monahon

  Ten Centuries

  Points: 1282

  More actions

  December 29, 2004 at 8:27 am

  #535270

  Hello Jacob,

  For the FK field in the Response table:

  - Leave "Validation Rules" blank. 

  - Put "No" in for "Required".

  For MS Access, the "Required" attribute specifies whether to ALLOW NULLS or not.

  That should do it for you.

   

  ---

  Regards,

  Bob Monahon