Hi guys !!!
I am using VB to conect to sql server . now i have the problem that:
I have a table in this table it have a fiedl that is automatic identity incrementally.
for ex :
that fiedl have 5 records : 1,2,3,4,5
every time when i open the form in order to delete 1-4 after that I addnew, i have the new record is 6 . it 's ok for me. it's exactly.
but when I delete 1-5 after that i addnew i have the new record that is : 6 ; so i want to be 1 ( because I have deleted all records,1-5 )but i have the result is 6; it' s not correct for me. so could anybody show me how to do that correctly.
thank