Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Random ID with Text

Status
Not open for further replies.
guitardave78

guitardave78

Programmer
Sep 5, 2001
1,294
GB
Hi I have 4 tables, Client, Job, Referer and Invoice
I want each one to have a unique field that will consist of 3 letters and a random 4-5 digit number, IE

CLI1234
JOB1234
REF1234
INV1234

I know that it is frowned upon to use the format in the random number for the unique identifier. I dont care how it is done as long as it works and i can search for them !!!

Thanks
 
Status
Not open for further replies.

Similar threads

JayRo71
  • Locked
  • Question
Saved Imoorts problem with file name
Replies
10
Views
487
Andrzejek
Andrzejek
TrekBiker
  • Locked
  • Question
Using old IDs as Autonumbers 1
Replies
6
Views
438
Andrzejek
Andrzejek
Anthony343242
  • Locked
  • Question
MS ACCESS UNION ALL with Attachment data type 1
2
Replies
29
Views
4K
Anthony343242
Anthony343242
jjMedrano
  • Locked
  • Question
UNION ALL with Attachment data type 1
Replies
8
Views
315
Andrzejek
Andrzejek
BugZap13
  • Locked
  • Question
How to extract Access table schema with decimal places on numeric fields?
Replies
2
Views
2K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top