What is the best way to have a customer balance that updates based on orders recorded on a separate table
Sent from my BLN-L21 using Tapatalk
Novice
Windows 10 
Access 2013 64bit
What is the best way to have a customer balance that updates based on orders recorded on a separate table
Sent from my BLN-L21 using Tapatalk
Who is John Galt?
Windows XP Access 2007
I split your question out to a new thread since it was unrelated to the thread you posted to. Typically its best not to try to keep a field updated; you just calculate the balance on the fly. You could have a query that calculates balances and join to it.
General Ledger Query With Opening Balance and Running Balance
Update the Customer No in real time
Add Customer Name into Customer Table each time a Unique Customer added to SaleTable
Posting Permissions
Reply With Quote