Question on the Northwind DB regarding the Orders Form and OrdersT

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
Dan said:
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!
Click to expand...

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!
 
Brian:
Thanks! That's just what I wanted!

Brian said:
Dan said:
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!
Click to expand...

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!
Click to expand...
 
Back
Top