Need to show unique value on choice list

[TejasviR]

Hello Everyone.

I Have a field (B) on my record producer where which is dependent on field A. Now I want to show only unique value in field A. For example on my table field, A contains --> Active store, Active store, Active store, Active store, ACL, Active, Active, QHCL, QHCL, QHCL, QHCL.  I want this Active Store, ACL, ACtive, QHCL this list whenever the user clicks on A field on the form, and as per that value dependent value will be shown on field B. Please help me with this.

Thanks in advance

[Allen Andreas]

Hi,

Unfortunately, you didn't tell us what type of field this is, but if it's a Lookup Select Box type, you can use this in the variable settings: "Unique values only"

Please mark reply as Helpful/Correct, if applicable. Thanks!

[TejasviR]

Sorry, my bad. it's a reference field.

[Murthy Ch]

@TejasviR 

If you are using lookup select box variable you can have a Unique check box.

Thanks,

Murthy