Lee Einer said:

> I am trying to set up a database to track my jewelry inventory, using
> StarOffice as a front-end to Adabas. What I am trying to do is get an
> item number to auto-assign as a primary key when a new record is opened
> up using a form. What event should I use for this, and what macro should
>  I use (assuming that Star Office has a standard macro and I will not
> have to write one.)
>
> I have attempted to divine the answers using Star Office help and the
> StarOffice 6.0 Office Suite Companion, but I am having buzzard luck.

If you are not hooked on StarOffice.  GNUe Small Business has item
maintenance that currently does what you are asking.  Inventory is not far
behind.

http://www.gnu.org/software/gnue-sb/

-Derek