title: Set default or set null for foreign key in MS access
body: <p>I am unable to set default or null value in MS access. For example, when I tried to delete parent row, the foreign key of the affected child row is not set to NULL. I have tried setting default value to NULL at the design view but it does not seem to work.</p>
  
  <p>Here is my sample data: <BR>
  In staff table: <BR>
  <code>ID | Name</code> <BR>
  <code>1  | Tom</code>  <BR>
  <code>2  | Tim</code> <BR><BR></p>
  
  <p>In customer table: <BR>
  <code>ID | Name  | processed_By</code> <BR>
  <code>1  | cust1 | 2</code> <BR><BR></p>
  
  <p>If I were to delete Tim from staff table, cust1 still retains 2 in <code>processed_By</code> column. However I wanted it to perform the following after deleting Tim from staff_table. <BR></p>
  
  <p><code>ID | Name  | processed_By</code> <BR>
  <code>1  | cust1 | NULL</code> <BR></p>
  
  <p>OR</p>
  
  <p><code>ID | Name  | processed_By</code> <BR>
  <code>1  | cust1 | 1</code> <BR></p>
  
  <p>Hope that you can help me to solve this question. Thank you.</p>