Alright, I have this Access Database. It has 6 Columns:

Code:
ID | Class Name | Class Code | Class Room | Grade | Teacher
My ID is the Unique Column that I need to reference back too when Updating my other Fields so I get the correct field.

How do I do this? Properly.

I've been thinking of a method but I doubt it would work.

First I would start off selecting all the ID's and then LOOP through all of them, and then rewrite them to to + 1 Each time I make a Delete, so Each Time it will be a consistent 1 2 3 4 5 6 7 8 9 10 .... etc... Then I can reference from that to my Combo Box Selected Index + 1 to get the Correct Row which corresponds with the Selected Item.

Will this work? Or will I still need a Unique Fields that I reference back too.