Hi! I followed so far till Expert8, but unforcedly I got here stuck, I listened over and over the lessons and can't catch what I am doing wrong. I build the orderF and then the orderdetailF but when I want to put in a new record to an old order it only gets the record of what I put in but without updating the rest of the values to that item
I'm not sure I follow. Can you provide a little more detail?
Abraham BreuerOP
@Reply 6 years ago
i buildcustomerT, product, orderT, orderdetailT, then a query that puts together the product names ect. to the orderdetail, then i built orderF, then a orderdetailFfor a sub form, so when i open up my order form and it displays the sub form if i am putting in a new detail into the orderdetail section, it wouldn'tcome up the price, instead, it comes up to $0.00, I hoped that if I build a query putting the product and price together with the orderdetail ID it should come up the price when enteringjust the product item,
Yep. That's how it should work. As soon as you select a product with the combo box your price should update. Check your query. Possibly something spelled wrong.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 8.
