A little harder thing i need help with

[Guest]

hey its me again.

i have a table of alot of car names with a field marked quantity showing how
many of each there is. like i said in the other post.

i have also made a sales table which includes the customer, the car, & how
many they want to buy of that car.

i want to know how do you update the quantity field of the car table after
every sale.

e.g. if there are 15 cars, 2 were sold 15 should automatically change this
to 13.
could any1 provide a clear step by step method to do this. i think it
involves using a query

 

[pietlinden]

hey its me again.

i have a table of alot of car names with a field marked quantity showing how
many of each there is. like i said in the other post.

i have also made a sales table which includes the customer, the car, & how
many they want to buy of that car.

i want to know how do you update the quantity field of the car table after
every sale.

e.g. if there are 15 cars, 2 were sold 15 should automatically change this
to 13.
could any1 provide a clear step by step method to do this. i think it
involves using a query

you don't. You create a query to calculate it for you.
You should download Allen Browne's Quantity on Hand database and read
his notes on it.

www.allenbrowne.com

it's in one of the Tips for serious users section, I think.