title: Access error saying related record is needed
body: <p>So I have set up a database to record files in boxes. I already have all of my boxes entered onto their table, and we are going through and entering the data from the files. </p>
  
  <pre><code>+WarehouseTable            +FileTable              +FileStatus
  -id                         -id                   -id
  -box                         -data                 -who
                                                      -date
  </code></pre>
  
  <p>For my inventory form, I have the box inventory as the main form, and then a subform to enter each file within the box. I also have hidden fields on the subform to save the user and date on a separate table for every record entered. </p>
  
  <p>So when the user signs in, they navigate to their box number, and then are free to enter the file records in a datasheet style format. So when they tab down to the next record, some people keep getting error messages saying that a related record is needed. But it only happens to certain computers. </p>
  
  <p>I've looked at the record sources for the forms and they seem to be fine. I haven't had data entry turned on so that they can see what records have been filled out all ready. Do you think that could cause an error?</p>
  
  <p>Because all of the boxes are recorded already, I am unsure why it keeps saying a related record is needed from that table. </p>