i am using access with VB. i hv a flexgrid for populating records.here am using 4 fields for a record that are.....sno, appointments, date and time. and i hv 3 buttons in VB add, update(modify) and delete buttons. sometime i use to delete some records in my table using delete stt. at the same i use to call flexroutine to update msflexgrid too.
suppose am deleting 3rd record. that is am deleting record with sno. 3, then there will not be sno. 3 record in table. then sno. series will be 1,2,4,5....
my doubt is how can i make these numbering continous after deleting one or more records. here sno. field not an autonumber field. me only giving the numbering using code.
thanx in advance-------------saj