hey guys,
i've jus started working with procedures.. I'm having a form with several controls say, date, name, adress,time.. etc.. etc.. once i eneter values in these fields n press save, all the values get saved in the database..a procedure has been written for doing this n everything is fine till now..

But ther's one more field called 'customer no', which shud auto-generate the value :CN1 for 1st customer, n CN2,CN3 so on...