Creating an ID #

[scsuflyboy]

I have a table (and forms) to track lease information. One of the fields is labeld TENANT.

I want to be able to create a unique ID for each lease file I create with the following format..

1st three letters of the TENANT name, followed by a 3 digit number (i.e, Tradewinds Contracting would have an ID of TRA001. If Tradewinds Contracting has multiple lease files they would have ID's of TRA001, TRA002, etc. Oingo Boingo Sales would have an ID(s) of OIN001, OIN002, etc.

How can I accomplish this? I will say I am not a professional programmer (I'm a novice to say the least).

Thanks in advance.

 

[GKChesterton]

So Oingaloid Bongos would fall in as OIN003, correct?

I think a quasi-meaningful index won't serve you well. So you have OIN002 -- you still need to look up and see the name of the company and which lease is referenced. I don't say this to slight your knowledge of leasing, but rather of the use of the database. If you "let the computer do the work," the index number is both non-meaningful and out of sight; you'll find this works well in my experience.

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​