How to display unique value in reference field

[Sachin G K1]

Hi All,

i have a reference field(ci class)>referencing "u_ci_class_lookup". This reference field is having duplicate records. how to remove this duplicates.

[Sachin G K1]

Thank you

[Sachin G K1]

hi rasheed,

i tried it. but didn't get expected results

[Ankur Bawiskar]

Hi,

First question -> how are you determining the records are duplicate?

Second question -> why there are duplicates

Possibly if you clean up your table there won't be any duplicates

Regards
Ankur

[Ankur Bawiskar]

@Sachin G K 

Did you get a chance to check my above comment?

Regards
Ankur

[Sachin G K1]

Hi Ankur, 

I resolved it. thanks