Hi guys;
I am developing a new database for a water utility and one part is billing of customers, now my problem is that when I want to create a new bill for a customer the following should come to bill fields automatically.
1. when I enter a customer number the last number of its meter should appear in a specific field
2. if there were any remaining balance that he/she didn't pay should appear in a specific field
also for reporting, I should be able to know the remaining balance of each and total customers.
Thanks for your help in advance dears.
I am developing a new database for a water utility and one part is billing of customers, now my problem is that when I want to create a new bill for a customer the following should come to bill fields automatically.
1. when I enter a customer number the last number of its meter should appear in a specific field
2. if there were any remaining balance that he/she didn't pay should appear in a specific field
also for reporting, I should be able to know the remaining balance of each and total customers.
Thanks for your help in advance dears.