title: Microsoft Access cannot add records join key of table not in recordset
body: <p>I know this is a repost, I have done my research on everything possible and I couldn't find anything to assist nor help me with my current problem. No matter how many times I re-create my Query or Form, I just can't seem to get it to work correctly. if I run my Query, I will get the correct information displayed, but when it comes to adding information through a custom form I made, I get this error -> <code>"cannot add records join key of table not in recordset"</code>.</p>
  
  <p>My current Query, incase you wanted to see. I only access vendorNoID from the vendor table. I require all the information from the rest of the tables.</p>
  
  <p><img src="https://i.stack.imgur.com/mvmfA.png" alt="enter image description here"></p>
  
  <p>I am able to enter information in this form for tbl_address and tbl_addressType, but I get the error for vendor / purchaseOrder. Any reason whats causing this?!?!</p>
  
  <p><img src="https://i.stack.imgur.com/Ve8Q6.png" alt="enter image description here"></p>
  
  <p>Any advice will be greatly appreciated</p>