ID field

Bhavini Patel · Aug 5, 2003

How can you design the database so that the ID field is
set to a number which is not 0 (the default)?

chas · Aug 5, 2003

Hi Bhavini,

Open the table in design view, select the ID field and
change the Default Value property to whatever you want it
to be. Of course, if it is a unique indexed field you
will not be able to add more than one record with the same
value.....

hth

chas

TC · Aug 6, 2003

Bhavini Patel said:
How can you design the database so that the ID field is
set to a number which is not 0 (the default)?

Use an autonumber field?

HTH,
TC