update a field when another field is edited

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to automatically update my "Inventory" field in table1 when "Items
sold" in table2 is changed.
 
Don't we all...

You're going to need code that reads the ItemsSold record in table2,
adds or subtracts the appropriate number and then updates the ItemsSold
number accordingly. Without knowing more about your layout or
functionality I can't be of much more help than that.
 
Back
Top