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.
 
You must log in or register to reply here.

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

Access Scan a UPC on a txtfield on mainform & add to subform Please Help! 1
Add/Subtract columns from tab to tab in same file 3
Access Daily Entry with multiple entries per field 0
data is repeating itself 25
Attempting an inventory management database 7
Access Main form/Subform Navigation 0
Duplicate records in split database 5
Inventory levels in stock control database 5

Back
Top