hello guys,
i would like to know how can i automatically fill the fields of a page once i select a customer number
my card has 8 fields: (customer number, name, number , county code, county, sub county, estate, estate code) which are used when applying for a service
this data is stored in 3 different table
1. customer table has the fields customer number, customer name, number
2. sccounties table has the fields county code, county, and sub county
3. scestates table has the fields estate and estate code
when a customer makes a service request, all this information is filled the first time.
is there a way, where once the information about a customer has been entered and saved, if the same customer again makes a service, the system will automaticaly fill all other fields once he fills the customer number
thanks
