>I am trying to create a table of users for my application. I have 2 fields one named userno and one named username. How can I automatically create the usernumber when creating the user. therefore autocrement the number by one each time. Is this possible?

Neil,
It's possible.
-If you'd do that prefer methods saving the id in another table over autoinc fields.
-IMHO instead use GUID as key. My .02 cents
Cetin