HTML Page

  • Thread starter Thread starter Pras
  • Start date Start date
P

Pras

Hi,

I have a HTML page designed to update the database. Table has total 120
entries. ID field is the Primary key so their are total 120 ID. Now when i
add a new entry it shows 121 in id field but when i click on save it changes
the ID no. and assigns 65327 and so on. Could any one please asist me on the
same.
 
Apparently your autonumber has been changed from sequential to random. It
there is only 1 table, delete and recreate it with the same name.

If you have related tables, you are probably better off leaving it alone and
living with the random ID. IDs are really designed to maintain relationships
between tables, not provide any human readable meaningful data.
 
Back
Top