Peoplecode for dropdown

 Local SQL &SQL;

/* Clearing all existing values that were with AddDropDownItem() */

RECORD.FIELDNAME.ClearDropDownList();

/* Creating SQL for fetching values to be added to the drop down */

&SQL = CreateSQL("SELECT A.FIELD2 FROM PS_RECORD2 A WHERE A.FIELD3= :1", &para1, &out2);

While &SQL.Fetch(&out2)

   /* Adding each row from the SQL's output to the drop down  */

   N_RUNCNTL_SCI.INFOSILEM_DBNAME.AddDropDownItem(&out2, &out2);

End-While;