3
Reply

Auto generate customer number [ref. must be from 2 tables]

Hold On

Hold On

Mar 14 2017 9:19 PM
195
Once again I needed your precious help.
 
I have 3 tables in sql server 2014 namely: tblBranch, tblAgents & tblCustomers. I need to have an auto generated customer number with format numbers: xx yyyy zzz, where xx is the branch code(string type), yyyy is the agent code (string type) and zzz is the customer series number also in string type. Below are my tables.
 
 

Answers (3)