Hello David, If it possible, consider and archival reference table for this information. It may required more coding on your part to look at this table before adding a new customer or changing reports to include data from the archival table but it might prevent data integrity problems. Good Luck, Manuel David Ebert wrote: > 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]
begin:vcard n:de Aguiar;Manuel tel;fax:(323)661-7698 tel;work:(323)660-3511 x-mozilla-html:FALSE url:http://www.mdenterprises.net org:M|D Enterprises adr:;;2412 No. Commonwealth Avenue;Los Angeles;California;90027-1206;USA version:2.1 email;internet:[EMAIL PROTECTED] title:Developer note;quoted-printable:The information contained in this e-mail may be privileged, confidential,=0D=0Aand protected from disclosure. If you are not the intended recipient, you=0D=0Aare hereby notified that any dissemination, distribution or duplication of=0D=0Athis communication is strictly prohibited. If you have received this=0D=0Acommunication in error, please notify the sender immediately and delete all=0D=0Acopies.=0D=0A=0D=0Ahttp://www.mdenterprises.net=0D=0Ahttp:/www.databasedeveloper.com=0D=0Ahttp://www.MdrBASE.com=0D=0A x-mozilla-cpt:;-1 end:vcard
