I have a form that has multiple queries. Each query produces a specific list of items, and when the table is manually filled, it shows the amount of each item ordered, on hand, etc..
My problem is that when I try to enter in an amount into one of these fields on the form, it does not add a new line into the table, which gives me the "a related record is required in tblBOMmain" error.
How does one go about adding a line to a table when a specific line of a query is edited?
I have located the issue with my problem. One of the "Not Shown" elements in the query is not being filled with the correct number.
I figured this out by Showing all of the fields and running the query.