need help with how this is done

[Rob McDonald]

I want to build a database which will help my parents with invoicing at the
small company they own. Presently theya re at invoice number 15133 or so
doing everything the old manual way. I want to continue on where they have
left off with the database. I want to use invoice number as the primary key
and have it start there. Is there a way that this can be done? Any help
would be much appreciated

 

[Arvin Meyer]

I want to build a database which will help my parents with invoicing at the
small company they own. Presently theya re at invoice number 15133 or so
doing everything the old manual way. I want to continue on where they have
left off with the database. I want to use invoice number as the primary key
and have it start there. Is there a way that this can be done? Any help
would be much appreciated

You can use an autonumber, or write your own code. If you use an
autonumber, append a record with an invoice number of 1 less that the number
you want to start at to your table. After you add your first "real" record,
you can delete the dummy record and Access will increment properly from then
on.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Rob McDonald]

Tahnk you very much for the help on this item. I appreciate it ! Have a
great New Year