Serial Numbering

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

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
 
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.

AVIJIT SIRCAR said:
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
Click to expand...
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...
 
Back
Top