Question on the Northwind DB regarding the Orders Form and OrdersT

[Guest]

I am working on a new Call Log DB in which the Call Log Form will assign an
unduplicated Call Number for each new record. I'd like to use the Primary Key
[CallLogID] of my Call Log table to be this record number. However, I'd like
to start the record numbering with a 5-digit number, eg: start numbering at
10001, not 1.

I've looked at how Northwind does this but I can't figure it out. Ther
Primary key of the Orders table starts with 10248. Is this done in code or am
I not seeing all the previous Orders, starting with 1?

I've asked a similar question this Forum before but I don't think I
explained it clearly, so I'm trying again. Sorry for the duplication!

 

[Brian]

I am working on a new Call Log DB in which the Call Log Form will assign an
unduplicated Call Number for each new record. I'd like to use the Primary Key
[CallLogID] of my Call Log table to be this record number. However, I'd like
to start the record numbering with a 5-digit number, eg: start numbering at
10001, not 1.

I've looked at how Northwind does this but I can't figure it out. Ther
Primary key of the Orders table starts with 10248. Is this done in code or am
I not seeing all the previous Orders, starting with 1?

I've asked a similar question this Forum before but I don't think I
explained it clearly, so I'm trying again. Sorry for the duplication!

Here's a way to set the starting value of an autonumber to a value you
choose:

http://support.microsoft.com/kb/209696

You don't need any code, it only needs to be done once!

 

[Guest]

Brian:
Thanks! That's just what I wanted!

I am working on a new Call Log DB in which the Call Log Form will assign an
unduplicated Call Number for each new record. I'd like to use the Primary Key
[CallLogID] of my Call Log table to be this record number. However, I'd like
to start the record numbering with a 5-digit number, eg: start numbering at
10001, not 1.

I've looked at how Northwind does this but I can't figure it out. Ther
Primary key of the Orders table starts with 10248. Is this done in code or am
I not seeing all the previous Orders, starting with 1?

I've asked a similar question this Forum before but I don't think I
explained it clearly, so I'm trying again. Sorry for the duplication!

Here's a way to set the starting value of an autonumber to a value you
choose:

http://support.microsoft.com/kb/209696

You don't need any code, it only needs to be done once!