Updating Tables

[Greggscott47]

i have a multi table database

i have 2 tables in there which are related by the product id ,

i want the product table with the qty_in_stock to be updated , when a value is entered in the order table

what i want it to do is update the qty when the value is altered in the order table or a new order is added

can any body help

 

[montrose]

Greggscott47, Calculations, per se, should not be stored in a table. However, the actual 'updating' of your quantity will most likely be done through a query. If you post your table structure, may be able to help more. Or you can re-post your question in the Microsoft: Access Queries and JET SQL forum and and someone can help get your query to produce the results you want. May also want to do a search in the Microsoft: Access Queries and JET SQL forum and see if a similar question/solution has been posted by others. Or in the Microsft: Access Other Topics. Think I remember seeing that addressed there. Thanks, HTH, montrose Learn what you can and share what you know.

 

[JeremyNYC]

There are no triggers in Access, which means you'll have to make those changes happen through code on your forms. And you probably don't want to store the quantity on hand--it would probably be better to store how many things you start with, how many things come in, and how many things go out. Those numbers will have to be stored, which means the qty on hand will be a duplicate, calculated value, which is quite risky.

Try setting up your tables like that and then give it another try.

I would actually suggest you don't repost this question until you've tried again and come up with different questions. You'll get more responses here, and reposting means that people will be having two conversations without the benefit of seeing what half of the people have said.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.