Hello everyone,
I need some help tp design a table. The scenario is as follows. I am to create a table to hold the details about the customer which includes fields like Name, Address, Contact No., Email ID. I use the autonumber to generate the CustomerID. This customer has enrolled his brother also with the company. Now my problem is to link the main customer and his brother using the same ClientID.
Analogy to the issue is Customer having different accounts with the same bank. For ex. Mr. Adam is customer of XYZ bank. The customer id is as follows
Savings Bank A/c 001-712641-100
Current A/c 001-712641-200
Fixed Deposits: 001-712641-300
The client id is 712641 and the last 3 digits (ie, 100, 200, 300) denote the account type.
I need to create a similar kind of number for the above scenario (ie Customer family members also get the same customerid and some sufix to distinguish them). Kindly someone advise me on this.