Add 1 to next column
I really need some help with this one.
This is my problem I have a program in which I enter person(s) names in a database on a daily basis. I have 3 columns an Identification Column, a Name column, and a Number column. When the program is ran it automatically puts a 1 in the numerical column of the first Identifiaction Colunm. And the stored procedure calls for the name with that has a 1 in the numerical column. When I press next. I want to add a 1 to the next person in the database and change the current person with the 1 to zero. So no matter who presses next, the program will pull only the person with the 1 in the numerical column. I know i need some type of loop because when the list gets to the end of the database it needs to start back at the top..
Can anyone help??