I have a form, where users enter an order # (key) and who they are. All in table [CMSC_ORDER] (see links below).
From there, I want them to be able to enter the NSN # (combobox) and have the description, and price fill in. (all in table [CMSC_ORDER_Details]
I then want to be able to have a text box in the footer, that will calculate the order total, and store it in the CMSC_ORDER_DETAILS table under total, something like =sum(price)*(qty)
I was able to get the data to show up using nsn.column(1,2,etc), but the data is not stored under CMSC_ORDER_DETAILS.
http://s50.photobucket.com/albums/f3...=FORM_VIEW.jpg
http://s50.photobucket.com/albums/f3...esign_View.jpg
Any ideas?