Auto number / serial number

[JasonSummers]

I am currently modifying a lotus approach database. The “Item Number” field has the following definitions FIELD NAME = pl_no DATA TYPE = Numeric SIZE = 5.0 FORMULA/OPTIONS = Auto-enter Serial, Unique … it has been set to increment by 1. This works great if you are entering data through the form screen. But I also have it linked to a macro in an Access database that does an append query to a table that I have linked to this approach table. I currently do not assign values to pl_no when I do my append query because I am not sure how to do this and let lotus know what no’s I have assigned. If the last pl_no entered into my Approach db was 4573 and I import 1000 items, I need it to assign or at least understand that these numbers are now the ref. as to what number needs incremented. (It needs to start the next item at 5574 not 4574). If I have not made the problem clear, please email me and I will try to give more details. I need it to work a lot like an auto number key field in access. Thanks Jason

 

[paulbent]

One possibility might be to automate Approach from Access using VBA and create any Approach records using a view and DocWindow methods. This would cause the auto-serial field to work.

The other possibility is to remove the auto-serial option and maintain your own in a control table. If you register at

http://www.xpertss.com

(free) and go to the Approach - FAQs - Tips folder, the method is described in "Maintain auto-serial numbers when creating records with a ResultSet object"

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk