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?