Serial Numbering

[Guest]

Kindly tell me how do i include a Serial Numbering into an existing table after adding a new field to the tabl
e.g. - I have a table by the name of TEST with some records. Now I enter a New Filed with the name SLNO setting it as a Primary Key. Now I want to Fill-up the SLNO rows with running serial number automatically as per the total number of records in the Table - How do i proceed... pls help..

Thanx and Regard
Avijit Sircar

 

[Andrew L.]

Your autonumber field does this job for you, automatically.

If you don't have an autonumber field, in table design change the data type of SLNO to "autonumber".
This will fill up your table with sequential numbers.

BTW you can't have more than one autonumber field.
Andrew L.

Kindly tell me how do i include a Serial Numbering into an existing table after adding a new field to the table
e.g. - I have a table by the name of TEST with some records. Now I enter a New Filed with the name

SLNO setting it as a Primary Key. Now I want to Fill-up the SLNO rows with running serial number
automatically as per the total number of records in the Table - How do i proceed... pls help...