Hi  @LouisNji;

Please check how they've used ID to populate distinct values(https://help.k2.com/onlinehelp/K2smartforms/UserGuide/4.7/default.htm#Picker_Control.html), also check out with this tool(https://community.k2.com/t5/K2-blackpearl/ADO-Query-Service-Broker/ba-p/62327#)

Kind regards;

Widson.

Hello Widson,

Thanks for your response. Am working on K2 Cloud and i dont have access to any customisation

Hi  @LouisNji;

Thanks for the feedback, please see this formal cloud documentation,bare in minds it's up to your descrition on how you resolve your distinct value from your smartbox via smartbox(https://help.k2.com/onlinehelp/k2cloud/userguide/current/default.htm#create/K2Designer/Controls/Picker/PickerControl.htm), preferbly retrieve value by ID.

Regards;

Widson.