Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 343
  • Last Modified:

Access 2007 Another Question related to the other questions on the TradeShow

Hello,

Please find attached Order subform we have developed from a query.  The reason we want the user to enter codes and have the description come in automatically.  We do not want the user to enter anything in But Code and Qty.  Our Update Query is updating the Product Orders file, but our displays are showing incorrect data, becuase everytime the Order SubForm loads and a code is put in, the display available is doubling and giving waco results for available.  We need to know a correct available for each product code after a sale is made.

We do not want the query that handles the order subform creating bad results.  So we have our data correct in the product table each time a product is sold, but eroneous results occur when we try to enter additional records, becuase multiples are occuring.

jjc9809
Update-query-question.png
0
jjc9809
Asked:
jjc9809
1 Solution
 
AielloJCommented:
jjc9809:

There isn't enough information from that screen shot  to figure out what's going wrong.  One point I will make is standard database design practice not store values that can be calculated - such as your quantity.  Storing data that constantly changing introduces errors in many cases.

In the case of numbers doubling, it usually indicates a record in one table joins to more than one row in the table(s) it's joined to.

AielloJ
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now