Thanks guys for responding. This is a legacy app and I didn't want to change the "append blanks" to "inserts". The solution was to use a filter on the index. I have never before done that. Thanks.
>>i have a free standing table that i want to create a CANDIDATE index on to prevent dupes. here's the issue, the app requires a blank record. so how do i append a new record to this if i add the CANDIDATE index? i get "uniqueness violated" when i try to "Append blank" at this time.
>>
>>thnx
>
>Perhaps there is already a blank record?
>
>If you need several blank records, you can put a filter on the index, on
not blank(MyField).
>
>Also, you can avoid errors by either:
>
>(1) Instead of:
>
>
>append blank
>replace...
>
>
>you can use a single command:
>
>
>insert into MyTable (Field1, Fiel2) values (Value1, Value2)
>
>
>Or, use buffering. In this case, the candidate index (and other restrictions, like triggers created through referential integrity) will only be checked when the record is saved with TableUpdate().