I have 3tables.fruit/Sales/Fruitsales. I have created an Autoform from my table FruitSales, which I named as FruitSales (form). Fields present in my FruitSales form are FScode,SalesCode,Fcode,and Price.(which is same in the tablefruitsales).
I want (1) when I choose the fruit code on my Fruitsales form, the result appears in the Price textbox (result should be: the unitprice of the fruit * 1.15* Quantity)
The unit price is from the TableFruit, 1.15 is the Vat and Quantity is from the Tblfruitsales.

(2) Most Important: When the result is displayed. I want it to appear under the Price Field in my TblFruitsales.


HOW can I do that? Please Help!

Want to have an idea -Please Have a look at the FruitSales Form and at the Fruitsales table in the attachment

Thx