Best way to create own auto number practise?

[Ktx7ca]

OH the front ends are running on access 2003 and 2010.

 

[vbajock]

http://bytes.com/topic/mysql/answers/652076-how-create-identity-column-mysql

 

[Andrzejek]

best way to create my own auto number code

I do it something like this:

INSERT INTO tblMyTable([blue]MyAutoNo[/blue], ABC, XYZ, ...)
VALUES([blue](SELECT MAX(MyAutoNo) + 1 FROM tblMyTable)[/blue], 'AbcD', 123, ...)

Have fun.

---- Andy