auto numbers

  • Thread starter Thread starter Carl Johnson
  • Start date Start date
C

Carl Johnson

I've created a database using auto numbers as the primary key. I want to be
able to delete records and all of their relational records and then have the
auto numbers change to reflect a normal sequence. Can and how could I do
this without causing problems with my relationships? Thanks.
 
You can easily delete all related records in a second table by enforcing
referential integrity with a cascade delete.


You should not be using autonumbers if it is important to you to maintain an
uninterrupted sequence.
This is not the function of autonumbers.

HTH
- Turtle
 
Carl said:
I've created a database using auto numbers as the primary key. I want
to be able to delete records and all of their relational records and
then have the auto numbers change to reflect a normal sequence. Can
and how could I do this without causing problems with my
relationships? Thanks.
Click to expand...

You can set the relationship so Access will delete the child records
when the parent is deleted.

Autonumbers are designed to do only one thing; provide a unique number
for each record. Trying to keep them in any special order is only going to
frustrate your users. The best bet thing you can do is to never even show
those numbers on forms or reports. If people don't see them, they will not
get confused by them.
 
Back
Top