Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
Auto generate customer number [ref. must be from 2 tables]
Hold On
Mar 14 2017 9:19 PM
195
Reply
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.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
I want to get value from database with filter
SQLite/SQL Compact Toolbox cannot connect inside program