To manage data of two differents Ms-Access table from Visual Basic

Hi sir,

Please, I developing right now an application on Sales and Pusharsing management for a customer, but now I meet two problems :
1. To affect automatically the "SalesPrice" that`s stored in the PRODUCT Table to the INVOICE Table using PRODUCT ID primary key. For ex. VALUE = SaledQuantity * SaledPrice (from Product Table).

2. After processing the invoice, I need to have my Stock in PRODUCT Table being updated automatically ( STOCK = STOCK - SaledQuantity "in INVOICE Table").

Please, help me to resolve this problem.


Truly,


Naasson Fuka.