how to get unique values in reference field

[kapilscs]

HI All,

I have a reference field and the values in back end table are duplicate. I want to show only unique values in the field. how to achieve this? Thanks in advance for any help.

Regards

Kapil Shinde

[kapilscs]

It is a reference field, can we make choice field on a custom table. as the table name, which I have created, was not showing up in the choice field.

[Ahmmed Ali]

Hi Kapil,

One way to achieve this is, by using advanced reference qualifier. Create a script include to qruery the referenced table and return the comma seperated sys_ids of unique records.

[kapilscs]

Hi Ahmmed,

Will it be possible for you to provide a sample code.

Thanks

Kapil

[phillipmelmoth]

Kapil

From what I understand, you can't do this directly using the reference qualifiers and pickers.

What you can do is edit the list view of the references though so that users can tell how the records differ from each other.

If this is still a problem to you then you might need to consider cleaning up the target table or creating a new column with the unique values that the user can select.

If you don't care what record the user picks rather you just need the value in plain text then you can use a choice field and base the choice field on a table using the dictionary editor as another option.