Updating a table through a subform.

[paolo_maldini]

Hello everyone,,,

Here is my problem,

I'm using MS Access, I'm building a mobile inventory system.I have a table (Products) and I want to update the Quantity of mobiles each time I perform a sale operation. Sales operations are performed through a Form(Invoice) and in that form I built a subform-that was built using a query- where most of the sale details are specified. However, I don't know how I can subtract the quantity entered in the subform from the table's (Products) qantity to indicate the number of the remaining mobbiles.

Thank's a lot.

paolo.

[wlc04]

In the form footer you could try adding a text box then perform the calculation there to give you a new total of the remaining inventory. You will need a total of the items sold from the subform first.

[CaptainD]

You state "quantity of mobile" are you talking one item called "mobile" or you have different types of products ? I assume "Products". I also assume your invoice is like:
Qty Item price Total
2 Antenna's 10.00 20.00
1 AT1234 Battary 26.50 26.50

Total 46.50

Now, how are you displayng the information and how are you storing the invoice records?

I assume you have a Sales table with each invoice having a unique ID that ties the invoice to the sale and has the purchase product ID for each item purchase along with quantity etc.

On what ever you use to close out the sale or create a new record could run an "Update query" that updates the products table from the sales table for that invoice. That way each item pruchased is updated.

[paolo_maldini]

Thank's every one.

Yes I do have more than one product and they are included in the "Products" table. The sale details are included in a table called "Invoice Line".

Now my question is...What is an "Update query" ?