>I didn't see the reply I wrote - so forgive me if this is a duplicate msg
>
>do you use a collate sequence other than MACHINE?
>
>Arnon
>
>>
>>Thanks for your interest in helping.
>>
>>The fields are Field1 C(12) and Field2 C(16)
>>and the index is Field1 + Field2.
>>
>>The seek uses Memvar1 + memva2. Both memvars are previously converted with
>a padr() function to be the correct length for each.
>>
>>The table accepts the insertion of the duplicated value without an errror
>message.
>>
>>When I use and SQL the duplictes show up. Same as with a broewse with
>'nooptimze'. If I don't use 'nooptimize' in the browse the duplicates don't
>show.

Arnon, the collate sequence must be the default setting used by VFP5.0, I have never dealt with the collate sequence. I'll look into this.
Thanks,
Art Castro