Append query into a table with an autonumber

  • Thread starter Thread starter Stanley
  • Start date Start date
S

Stanley

I am trying to write an achive. To make it simple I have a
table with autonumbers. With a make table query, I can
select certain records, and put them into another table.
The problem is when I what to restore same of these
records.
When I put them back into the orignal table (with an
append query), the autonumber is set to the next highest
number of the highest autonumber achived. My orignal table
has higher numbers than that number, and so I have a
problem.
Any ideas,
Thanks,
Stan
 
Stanley

It might seem a move backwards, but why bother removing the records at all?
If you add a field (Yes/No, Date/Time) to use to indicate that a record has
been archived, you can modify your queries to exclude the "archived"
records.

Since they never leave the table, there's no autonumber issue...
 
Back
Top