So as a new developer, I'm running into some pretty mundane issues here and there.
Specifically- I've designed (most of) a database that I've attempted to have up and running for a small business.
A few days ago, I tested some of the features, and successfully printed from the Invoice form. It took data from the tblInvoices table and tblCustomers table exactly as it was intended to, but I never got around to making sure it could update to tables properly, or that a new form template would create a new record in tblInvoiceslike I want it to (for ease of access to invoicing for non-developers).
Since then, something went wrong, and now the form doesn't properly link to the other tables (some fields from tblCustomer are not edittable; and when changing any of the form control selections, I get an error to the effect of a join key not being in the recordset [?].
The biggest problem is of course that I haven't made any particularly large major changes since getting the printed invoice I wanted, and am not sure what I did to bring about these changes.
Attached is my database- I was hoping to get a little bit of help before I go ahead and put myself through the trouble of re-doing all of the relationships and deleting/remaking the form.
If that extreme sledgehammer method is indeed my only way of handling the problem- could someone still give me their best guess as to what could have possibly went wrong so that I may prevent it in the future?
Specifically- I've designed (most of) a database that I've attempted to have up and running for a small business.
A few days ago, I tested some of the features, and successfully printed from the Invoice form. It took data from the tblInvoices table and tblCustomers table exactly as it was intended to, but I never got around to making sure it could update to tables properly, or that a new form template would create a new record in tblInvoiceslike I want it to (for ease of access to invoicing for non-developers).
Since then, something went wrong, and now the form doesn't properly link to the other tables (some fields from tblCustomer are not edittable; and when changing any of the form control selections, I get an error to the effect of a join key not being in the recordset [?].
The biggest problem is of course that I haven't made any particularly large major changes since getting the printed invoice I wanted, and am not sure what I did to bring about these changes.
Attached is my database- I was hoping to get a little bit of help before I go ahead and put myself through the trouble of re-doing all of the relationships and deleting/remaking the form.
If that extreme sledgehammer method is indeed my only way of handling the problem- could someone still give me their best guess as to what could have possibly went wrong so that I may prevent it in the future?
Form Reference Error
