Thanks for everyone's help up to this point. I am almost done with this database. I have another question: Is there a way to reset the database autonumber without losing any of the data by deleting it, or do I have to delete the table and start with a new one?
I already put data in to test the functionality, but the auto numbering is off now.
Thanks
Sandra Truax
@Reply 13 months ago
If you have data linked to the table, and you change the autonumbers by creating a new table, etc. it does not update the related records and you will mess everything up. Might want to watch this video: AutoNumbers Are NOT For You
Sandra Truax
@Reply 13 months ago
If you do not have any data in any of your tables, running a compact > repair will reset your autonumbers.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
