Be careful on setting filters on indexes, especially primary and
candidate keys. The primary key has implication that it is
the only record with that key. If you have a ! DELETED() filter
on your primary key and delete a record then you have the
ability to add another record with the same key. If you
subsequently recall the first record you will receive an
error. Also if you linkage between this table and other
tables using the primary key this can distort your data and
audit trails.
The primary reason of not using filters on your indexes
is that they are no longer Rushmore optimizable.
-myron kirby-
==================================
>There's another heading you missed: Filter.
>
>
>Name Type Expression Filter
>Itemkey Primary ItemKey !DELETED()
>
>
>The !DELETED() command should go in the Filter column.