S
Sam
Hey ya'll... Thanks for the previous help I've gotten on
this newgroup and I hope ya'll can help me this time.
Form 1 (based upon query1 from two tables) is a subform to
enter in the products (drop down box) that automatically
enters in the Description (text box) and Unit Price
(textbox). Then the user enters in the Quantity (textbox)
and the subtotal is calculated. *When* the quantity works,
the subtotal calculation works just fine. I can only get
the quantity box to work by going back one record and then
forth again. And, of course, this is not only cumbersome
and annoying, but poor UI for the users.
Problem: I get an error "Cannot add record(s); join key of
table 'order details' not in recordset.
The two tables in the query are: Products and Order
Details. both have similar fields, as the Order Details is
supposed to keep track of the products being orderd.
(Perhaps this is my problem?). ANyway, the Primary Key on
the Products is productID. I *think* the join key is
OrderID (the primary key from the Order Details table).
However, both ID textboxes are on the form (although
hidden). Thanks again for the help!
sam
this newgroup and I hope ya'll can help me this time.
Form 1 (based upon query1 from two tables) is a subform to
enter in the products (drop down box) that automatically
enters in the Description (text box) and Unit Price
(textbox). Then the user enters in the Quantity (textbox)
and the subtotal is calculated. *When* the quantity works,
the subtotal calculation works just fine. I can only get
the quantity box to work by going back one record and then
forth again. And, of course, this is not only cumbersome
and annoying, but poor UI for the users.
Problem: I get an error "Cannot add record(s); join key of
table 'order details' not in recordset.
The two tables in the query are: Products and Order
Details. both have similar fields, as the Order Details is
supposed to keep track of the products being orderd.
(Perhaps this is my problem?). ANyway, the Primary Key on
the Products is productID. I *think* the join key is
OrderID (the primary key from the Order Details table).
However, both ID textboxes are on the form (although
hidden). Thanks again for the help!
sam