Dear Sinta:
Using an autonumber for a purpose other than uniquely identifying rows
in a table can be disappointing, even dangerous. Other than as a
unique ID, autonumbers have many side-effects that make them
inappropriate for other purposes which many developers seem to expect
will work well. Would you care to describe what you are wanting to
accomplish? I think you would get much better advice if you do.
Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
