B
Bill_ekit
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.
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.