one more thing - are you sure your key is marked as Candidate and not as Unique Arnon >>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