Subform Error Message



Hi Guys,

I am try to make a main form with a subform for invoices.

The tables I have are:

Customers : CustomerID, First Name, Last Name, Address etc etc
Products : Product ID, Desc, Price, RRP
Orders : OrderID, Date, Status, CustomerID
Order_Product : ProductID, OrderID

I create the main form which works.

I create a query of order_products and products with a join and then
put it as a subform but when I go to enter a new product via the
subform i get this error:

Anyone know why?

The query contains a join, and I have the child parent fields set.




What is the join you've created... according to the fields it looks like you
are using a junction table.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question