Hello.

I have a question regarding Index on DELETED() and a primary tag with !DELETED() as a filter expresion.

Let's assume that I have a customer table with cust_id as PK.
I remove a customer and add another customer with the same cust_id (cust_id is not a generated PK). This will generate a duplicate error message. So to solve this problem I add a filter expression on the cust_id PK: !DELETED(). Should I have an Index tag on DELETED() to optimize perfomance?

And there also seems to be a problem with connection with ODBC to this table when I have the filter condition !DELETED(). It says there is not deleted field. Anyone seen this before?