How to work with AutoNumber

[anwar jamil]

If you copy field having AutoNumber porperties to another table it does not work.So is there any way to work with AutoNumber

[This message has been edited by anwar jamil (edited 08-06-1999).]

[bashfirst]

You can't copy data into a Autonumber field, if that is what you mean... but why would you want to? One of those thumb rules of database design is to never have duplicate data in your database. If you have a list of names, for instance, and you want to reference those names against a list of library books and a list of automobile tag numbers then you would use just the autonumber key in those other lists. The field in those other tables would not be Autonumber, but a long integer.

Bash