Hi Abu!

I have a problem with a dependent dropdown, below is the code I use to generate inside the grid the 2 components. Whenever I edit a record it doesn't show the selected option of the 2nd dropdown. It is strange because when you see the record before you edit it, you see the dropdown with the selected option but not when you edit the record.

Below is the code of the 2 dropdown's.

$col = array();
$col["title"] = "Cliente"; // caption of column
$col["name"] = "idClientes"; // grid column name, must be exactly same as returned column-name from sql (tablefield or field-alias)
$col["editable"] = true;
$col["width"] = 200;
$col["edittype"] = "select"; // render as select
$str = $g->get_dropdown_values("SELECT idClientes as k, nombre as v FROM clientes ORDER BY nombre");
$col["editoptions"] = array(
"value" => $str,
"onchange" => array("sql"=>"SELECT idUnidad_Medica as k, nombre as v FROM unidad_medica WHERE idClientes = {idClientes} ORDER BY nombre",
"update_field" => "idUnidad_Medica")
);
$col["formatter"] = "select"; // display label, not value
$cols[] = $col;

$col = array();
$col["title"] = "Unidad<br>Médica"; // caption of column
$col["name"] = "idUnidad_Medica"; // grid column name, must be exactly same as returned column-name from sql (tablefield or field-alias)
$col["editable"] = true;
$col["width"] = 200;
$col["edittype"] = "select"; // render as select
$str = $g->get_dropdown_values("SELECT idUnidad_Medica as k, nombre as v FROM unidad_medica ORDER BY idUnidad_Medica");
$col["editoptions"] = array("value" => $str);
// initially load 'note' of that client_id
$col["editoptions"]["onload"]["sql"] = "SELECT idUnidad_Medica as k, nombre as v FROM unidad_medica WHERE idClientes = {idClientes} ORDER BY nombre";
$col["formatter"] = "select"; // display label, not value
$cols[] = $col;