Don't reuse the Primary Key.
>dear all,
>i've got problem here, help me...plz...
>
>i have a table with a primary key. i use it in a form so i can make a new record and delete it. the problem is there is an error, with the primary key, if i make a new record after i delete one record in that table. anyway, i won't be able to 'PACK' the table coz i use a grid in the form to browse all data/record. i've tried using 'SET DELE ON' & 'SET FILTER TO NET DELETED()' but it doesn't work.
>what should i do?
>
>thank's before...
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer