Khalil Islamzada
Registered User.
- Local time
- Today, 12:07
- Joined
- Jul 16, 2012
- Messages
- 49
Dear all;
I am developing a customer management database for a water utility, therefore I need to add billing option to database but I have one problem and hope you can help me.
I have a table and a form for billing with following fields
CustomerID
CurrentMeterNo
LastMeterNo
and other required fields
What I need is, When a new bill is recording the last value of "CurrentMeterNo" field appear in "LastMeterNo" field automatically.
Many thanks for your help.
Khalil:banghead::banghead:
I am developing a customer management database for a water utility, therefore I need to add billing option to database but I have one problem and hope you can help me.
I have a table and a form for billing with following fields
CustomerID
CurrentMeterNo
LastMeterNo
and other required fields
What I need is, When a new bill is recording the last value of "CurrentMeterNo" field appear in "LastMeterNo" field automatically.
Many thanks for your help.
Khalil:banghead::banghead: