I have Id field in the table whose data type is set to autonumber. The problem I am getting is suppose the last record added in the table has id=100 . If I delete this record then the new record will have id=101 but in actual I want Id=100 so it should be in serial order .
I want the code to check max id and then next id will be maxid+1.
Can I get this done with autonumber field?
Thanks
I want the code to check max id and then next id will be maxid+1.
Can I get this done with autonumber field?
Thanks