Auto product code change by a sequence

[Shafique]

I have worker ID codes e.g
my table name is "EMPLOYEE" and field name is "ECODE"
ECODE
P10001
P10002
P10003
here a event on afterupdate when i add another employee's name the ECODE will be P10004
and as so on

 

[welshgasman]

Use Dmax() and increment that value.

 

[Micron]

That's fine if the letters don't change. Even then, still might be. Who really knows exactly what is wanted?

 

[welshgasman]

Yes, no need for the P really.
As happens most times, insufficient information, so I just address the gist of the query, as I understand it, anyway.