I don't understand the question. Can you please be a little more specific?

I AM very sorry my english is so poor.

I want to automate soldprice (this price is from the orderdetail table *newprice*)

Orderdetail table:
Orderdetailid:autonumber
Orderid:number
Qty:number
Productid:number (from product table)
Newprice:currency

In afterapdate event
  
  Me.newprice=me.productid.column(2)

Automaticaly I get the newprice (if the product price changes <up/down>) but the previous price does not change.

Now from the *customer pricing 1* video, I know how to create A SPECIFIC PRICE FOR CERTAIN CUSTOMERS.

And in the afterapdate procedure (above) ,

   Me.newprice=me.productid.column(2)

the PRODUCTID I took from the CUSTOMERPRICINGQ (customer pricing ViDEO) ..... I GOT the NEWPRICE  E R R O R

In this CUSTOMER PRICING 3 video , does it show up HOW TO AUTOMATE THE PRICE USING QUERY (customerpricingq)

I want to buy one if it does

Thanks

Hopefully it is clearer now

Sorry....

If I change the PRODUCTID ( from product table) with the PRODUCTID i took from CUSTOMERPRICINGQ (customer pricing video) I got...E R R O R

Lien, what is the error?

productid of product table

it works well using productid of product table

customrpriceq...it is okay

ohh....Iam sorry it works fine as well.
I changed the productid of product table with PRODUCTID OF CUSTPRICEQ

I am very sorry

Glad you figured it out. Yeah, there's usually a little step here or there that someone misses. Or it's likely a spelling error. Something like that. If it works in the video (and in my stock database) I guarantee what I'm showing you works. Always retrace your steps.

thank you RICHARTS
firstly I got warning "IT IS INVALID FOR THIS FIELD!"

then I know the new price (final price in your video) format fuction was wrong, I did not use as yours (format(my price;"currency")
but format(myprice;"Rp #.### ,-") Rp is indonesian RUPIAH not "CURRENCY"

thank you very much

That's one thing I don't know much about: other language/currency/regional settings. Sorry.

I need to ask you something on your inventory extended cut video    
you open the update query  twice
  
   firstly right after creating the stockupdateq
   secondly after creating the event (before update;afterupdate...etc)

and BOTH diminish the qtyonhand twice too

now how about if I want to
       1. change the cup cake qty (in the orderf) to 3
       2. change the cup cake to tribble bait

thank you

what I meant was how much THE QTYONHAND decreased after changing cup cake to 3
and if the cup cake changed to tribble bait (because the order should be tribble bait) was it changed the qtyonhand of cupcake to 10 as well

thank you