Knowing what is added/deleted in subform?

  • Thread starter Thread starter nmccamy
  • Start date Start date
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?
 
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.
 
Back
Top