B Bhavini Patel Aug 5, 2003 #1 How can you design the database so that the ID field is set to a number which is not 0 (the default)?
How can you design the database so that the ID field is set to a number which is not 0 (the default)?
C chas Aug 5, 2003 #2 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
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
T TC Aug 6, 2003 #3 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)? Click to expand... Use an autonumber field? HTH, TC
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)? Click to expand... Use an autonumber field? HTH, TC
