Knowing what is added/deleted in subform?

N

nmccamy

I have an order entry app that will also keep track of
inventory stock quantities.

If a customer adds or deletes products in a typical order
entry subform, how do I know what they added or deleted
so I can update the inventory?

Is there a way to read each line of the subform so I can
tell what is going on during an update or delete?

What is the best way to accomplish this?

Seems this would be easily accomplished using a trigger
in SQL Server, but how is this done in an Access subform?
 
S

Steve Schapel

Nmccamy,

The best way to accomplish this is to not separately store "inventory
stock quantities". Whenever you need the stock figures, just obtain it
"on the fly" via a Totals Query based on the transactions table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto-Numbering in a Table in MS Word 1
Adding connection points to shapes manually/programmatically 0
Attempting an inventory management database 7
Order Entry type form to add to three tables 12
multiple subforms or updateable queries 2
Database to track inventory in company cars 3
Point of Sale database - does it exist? 5
Help needed with adding a record in a subform 1

Top