auto employee code

[Desikankannan]

sir,
iam doing project in vb.net with ms-access back end
i wants to create employee code like companyname+cod e
like western001....
pls help to genereate code
example once i save the button it will generate next code western0002.... so on

regards
Desikankannan.

Posted via DevelopmentNow. com Groups

http://www.developmentnow.com

[oracle]

Re: auto employee code

before you insert a record, query your database for the maximum id
first. then assign your prefix with it.

e.g.
employee(id,nam e)

SQL DML : select max(id) from employee

when u're inserting a record, combine your prefix with the id+1 :

"western" & id_form_db+1

somehting like that.

gurus please correct me.