In a client table I'd like to use autonumber to assign the id numbers.
However, I'd also like to include the clients from the last two (RBase)
databases going back about ten years (this for record management purposes).
Some of our client records may never have been in a database and there is a
possiblity that a large number of records may need to be inserted manually.
My question is will I eventually break autonumber in this way? I don't
understand what activities may cause RBase to quit autonumbering. I'd had
(few) problems in the past that I could fix by deleting and recreating the
autonumber, but I'd like to know if I'm setting myself up.
I've tested inserting numbers manually into an autonumber column and the
only effect I've seen is that the next autonumber skips ahead of what would
normally be assigned.
For instance, if set to increment by 100 I can insert four records and
insert one record (100, 200, 300, 400, 50) the next autonumber is 600. This
is fine, I don't need a rigid sequence -- no one will ever ask me what
happened to 500.
tia
paranoid Dave
[EMAIL PROTECTED]
