ID field

  • Thread starter Thread starter Bhavini Patel
  • Start date Start date
B

Bhavini Patel

How can you design the database so that the ID field is
set to a number which is not 0 (the default)?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to reduce number of fields 0
Errors in Autonumber ID field 4
Relationship Question 6
Auto Complete field 1
Edited data record to be inserted as a new data record under the same PO number in Microsoft Access 0
Relationship 2
String with Varying Letter followed by Incremented Number 3
Another relationship question 11

Back
Top