title: SQL insert into table gives me foreign key error
body: <p>Trying to create an entry in a table like this: </p>
  
  <pre><code>insert into movie(mvnumb, mvtitle, yearmade, mvtype, noms, awrds, dirnumb)
  values ('10111', 'Something' , '2012', 'Action', '5', '2', '10079')
  </code></pre>
  
  <p>and I get this error</p>
  
  <blockquote>
    <p><em>Msg 547, Level 16, State 0, Line 1<br>
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_movie_director". The conflict occurred in database "Assign1W13", table "dbo.director", column 'dirnumb'.</em></p>
  </blockquote>