I have a NEXT_NO table
1. Customer 1005
2. Deals 1
6. Item 5005

from the item form at the time of update I manage to insert the record
into the item table with the correct no from the NEXT_NO table which
is 5005 but I need to also update the NEXT_NO table for the item field
by one. This is not happening please help with an actual example