Hi,

I need to define a field called it as DUP to indicate if there is a duplicated record.

I used SELF relational such as

if serial# = SELF Serial# then DUP = Uniqued DUP = Duplicated.

Otherword: Dup = Serial# = SELF Serial#

It works fine , but it cannot use DUP as a key because it cannot be indexed

Is there any way to make DUP to be indexed without scripting.

Thank you very much in advance

If the DUP field is a calculation, you will not be able to index it, you will need to create a separate lookup field (DUP_lookup...text, indexed) that brings in the value of DUP. Make sure you turn on the indexing in the field option dialog. Then reference the lookup field in your self-relationship, not the original DUP, and that *should* do the trick.

I had a similar problem in a barcode inventory dbase.

Let me know if that helps.

Jon

I did try, but for some reason (or I missed something) I does not work. It (the New DUP index field) not return the value I want.

Can you give me a bit detail how please if you have a chance.

I just want a flag (indexable) that indicates which record is duplicated or not.

Thank

[email protected]

Huntsville, AL

Thank you for your request. The attachment is not the file I am working on, but very much similiar.

Please take a look if you have a chance

Thank you.

Dup.zip