Script to reset primary key Next Value number?
Is there a script that will reset the Primary Key in a table?
Have a delete button on a layout, which will delete an unused record from its source table. Once that's done, would like a script that looks at the maximum __kp_MyPrimaryKeyField number and adds 1 to its Serial Number | Next Value in the Auto Enter section.
Can this be done?