B
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
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