Hi friends
I have been using AutoNumber for years in the Db.tables as a primary key for linking to other tables. I remembered having read in this forum that it is not advisable to use this, why? I can see a problem of resetting it.
What is other best way to replace this with longInteger and yet act as primary key?
Also if a tableB is linked to tableA's primary key, how can i reset all tableA primary key and yet have tableB synchronized on these reset keys?
Appreciate your views.
I have been using AutoNumber for years in the Db.tables as a primary key for linking to other tables. I remembered having read in this forum that it is not advisable to use this, why? I can see a problem of resetting it.
What is other best way to replace this with longInteger and yet act as primary key?
Also if a tableB is linked to tableA's primary key, how can i reset all tableA primary key and yet have tableB synchronized on these reset keys?
Appreciate your views.
Alternative to AutoNumber
0 commentaires:
Enregistrer un commentaire