i have a table in access 2000 and in that i have a field called inv_no
i want to autincrement this field every time with 1 when the records are saved..
to be more precise, i want to create some thing like sequence or scale of oracle and Sql server..
i hope u got my point..
e,g:- if the value of inv_no is - 1
so the next time i save the record it should be 2 and so on...
Shaikh Muhammed Arif
Tel.:- 91-22-510 4837