Answered by:
Get access highest Index Key number

Question
-
User507348793 posted
Hi , im wondering how to get the highest number in access Key index Integer colom and when inserting data the nuber must be plused by one
For instance say i got a booking number 4 in the key index colom and when i insert a booking without out a booking number how can i add just one and insert it into access database so then in the colom it would be 5 and so on
Thanks
Friday, August 20, 2010 8:51 AM
Answers
-
User-1360095595 posted
In Access I think it's called an AutoNumber field. When you insert a new record, it will automatically increment the value for you.
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Friday, August 20, 2010 9:12 AM
All replies
-
User-1360095595 posted
In Access I think it's called an AutoNumber field. When you insert a new record, it will automatically increment the value for you.
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Friday, August 20, 2010 9:12 AM -
User507348793 posted
Thx for reply
Yes i know thanks but i need to do it with C# Coding
Friday, August 20, 2010 9:20 AM -
User-1360095595 posted
I guess I don't understand what it is that you need to do in C# since the field is auto-incremented for you. Can you clarify your needs?
Friday, August 20, 2010 9:41 AM -
User507348793 posted
Ill Get back to you i need to test out some stuff..
Friday, August 20, 2010 9:59 AM