SQL Database: Approval ID auto incremental
I am trying to manually insert approval records into the database, but I cannot figure out how to retrieve next approval ID for ApprovalDetails table (same applies to Approval_StageID). I tried following logic to get biggest number and add 1, but this doesn't work. If I will add several approvals directly inserting data to database, and then try to add through UI, it complains that this key already exists in the database. So looks like ID is getting stored somewhere, but I cannot find out where.
Any ideas?
Any ideas?