Alright. So after starting a new database from scratch, I have been able to successfully auto-fill a row in a form.
The dilema, though, is that I cannot add another row in the form without manually going to tblPartsPerOrder and starting a new row by inputting the JCSnumber. How do I make it so that this is automatic?
The error message is: "Cannot add record(s); Join key of table 'tblPartsPerOrder' not in recordset.
I have attached a copy of the database I am testing this on.