[AccessD] AutoNumbers in historical tables

Susan Harkins harkins at iglou.com
Mon Jun 30 09:46:47 CDT 2003



> You can set an autonumber field to any valid numeric value that doesn't
> pre-exist regardless of what the next number would otherwise be.  Multiple
> conflicting numbers would have to be preserved in separate tables or it
> wouldn't be an accurate history.  If you wanted to have a master
> reconcilliation, that would no longer be historical and there would be no
> point in keeping a unque index on the autonumber field.

==========But how would you interact with those different tables -- I
mean -- if you had 3 historical tables and they all had a primary key value
of 342, how would your application know which was the right record?

Susan H.



More information about the AccessD mailing list