Subform Error Message

[BigAl.NZ]

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:

http://img100.imageshack.us/my.php?image=screen3ee0.jpg

Anyone know why?

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

-Al

 

[Guest]

Al,

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

Maurice

 

[BigAl.NZ]

Al,

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

Maurice












- Show quoted text -

Have a look at http://img100.imageshack.us/my.php?image=screen2bz7.jpg

-Al