sequence # update in the database

Hi All,

I'm having a problem in updating seq# in the database, which is not a auto seq#.

I'm able to show the seq# in the view page from the database and the user can update from that page.The problem is the user can check any check boxes to delete n no of records.can choose 2, 5, 8 like....,

How to update the database seq# what records has been deleted and to do the update and display the records with the new seq #? in the view page.

Any clue?

Thanks....