A SALES Form that can update both PRODUCT & SALE Tables

A SALES Form that can update both PRODUCT & SALE Tables

Post by Bill_eki » Thu, 11 Oct 2007 18:35:07


Hi



Well, allow me to ask this question!

Am creating a Product-Sales Database, and I would like the corresponding
Sales made in the Sale Table to be automatically deducted or to be reflected
in the

Product Table. The product table contains all my stock and has a relationship
with the Sales Table. The Sale Table does not necessarily include the Stock.
How can

I create possibly a Sales Form that will be used as an entry point for all
the products (stock) sold and automatically register the sold products in the
Sales Table and

at the same time make the required adjustments in the Products Table.



I thank you a million in advance! Kit.
 
 
 

A SALES Form that can update both PRODUCT & SALE Tables

Post by Pete D » Tue, 16 Oct 2007 03:50:37

You might look at the MS sample Northwind traders
http://www.yqcomputer.com/