Posted 19 March 2008 - 10:58 PM
If you want something exciting switch the computer off and go abseiling or white-water rafting!!
Usually a Customer ID is the first few letters of the last name, then the initials, and maybe a number.
Eg - Fred Smith might be SMIF01
The Branch name would only be usefull if you are developing the program for use in several branches - and then only if there were a real need for one branch to have access to the customers of another branch.
Unless you have a very large number of clients, sorting your Database on Client Last name then the First name should give you an easily accessible list.
There are 10 types of people - those who understand binary and those who don't!!
Today is the Beta version of Tomorrow!