Removing duplicates from my lookup select box

[Cupcake]

Is there a variable attribute that I can use to remove the duplicates from my table.

I have a catalog form that has a variable that I set up as a look up select box from the table that I created.

I want to filter out the duplicates. There are duplicates because the table has three fields (Env, Server, and DB Name) - there are various DB Names that have the same env and/or same server

Thanks,

Karen

[Pradeep Sharma]

Hello Karen,

Navigate to the "Lookup select box" variable you have created and make sure unique checkbox is selected.

[Pradeep Sharma · Accepted solution]

Under type specification, you will see the unique checkbox. Set it to true. Screenshot for reference.