Hi all,

This one might be simple, but I still have no clue.

I have a table with a primary key field designed to be type integer(autoinc). My problem is that when a new record is appended, the autoinc also takes records marked for deletion into consideration and autoincrements those values also. I would like them to only include non-deleted records.

Thanks a lot.

With best regards,

Steve.