Forum Discussion
Microsoft Access Reusing Record ID's
I have a (Microsoft access office 365 database). I have a number of records in a table in the database. Lets say I have 5 records numbered 1 to 5 respectfully. now when I delete record number 3. Recor...
Spoiler
Use your own record number field don't use the automatically generated id field.
Unfortunately I use the autonumber as a record ID data type field in the table. I have about five hundred entries in the table. Even at this stage can I use my own record numbering system? I am not sure how to implement my own record numbering system.
