Agnes check for unique index on that table, if you have an unique index it shoould ignore deleted records e.g. Filter condition set to !DELETED().

>Hi all ,
>
>I delete a record in a table with delete but when I add a other record , a message appears that said yhe record is already exist
>
>nb : set deleted is on
>
>thanks