Cannot Add Record to Form?

[jedooley]

Can someone please explain what this message means. I am trying to add a record to table with a form. I am guess it has something to do with multiple tables the queries data comes from.

Cannot Add Record(s) Join Key of Table 'Delivery' not in Recordset

Is there another way to add a record through a form? Are Join not allowed when inserting new records?

 

[Pat Hartman]

Usually the RecordSource query includes joins only for "lookup" tables. You would NOT update the "lookup" table in the query only the many-side table. So for example an Order form will be based on a query that joins the Order table to the Customer table but the customer table will not be updated from this form.

I'm guessing that you have a 1-m join and are trying to update data from both sides of the join on the same form. You can do this but it is not recommended. Your problem is that you haven't included the many-side foreign key field in the query. To use our Order-Customer example, you would need to include the CustomerID from the Order table (many-side) rather than the CustomerID field from the Customer table (one-side).

 

[jedooley]

Thank for your response.

I have a table that Product, Client, Job, Delivery.
I was just wondering if it is possible to add new records through a form rather than getting people to go to the actual table itself.

The Job Table stores the ProductID, Client ID but all the info about the delivery is in the Delivery table. Delivery table stores the Job_ID. So Job table must be entered first and then delivery table. Is it possible to do this with a form?

thanks for your help