When I delete a record from my table, I am not able to enter in a new one. I get a unique index violation error. I have SET DELETED ON. I know it is scoped to the current data session, but that doesn't mean too much to me. When I browse the table exclusivly I can see that record, but is there a way to enter in a record that would receive the same ID as the one I deleted? The last record in my table has an ID of 11. I delete it. The next record I add in would receive the ID of 11, since it is autoincremented. But it can't because that other one is still in the table, its marked for deletion.

Thanks,

Tyler