Hello all,

I have a question. Is there a way that when you delete a record in Access that the record attached to that auto number will get deleted and not the number itself? Basically what I want is to have the autonumber match how many records there are on that table.

Thanks,
Chris

No.

What are you using that number for and where? There are other ways to generate that number on forms and reports.

The autonumber should remain invisible to the user.

mmcdonal

Basically I am using this autonumber as my key. I was just wondering if when a record is deleted and the update query is ran to the other records related to this record that the autonumber whould then get assigned to the next record in the database.

No. Since it is meaningless data, it is not necessary to reassign a used key. It is also dangerous since child records may get appended to the wrong foreign key.


mmcdonal