hi sir,

i have used Select 2 option for the drop downs.
it works well but i am facing a small issue?
i have tried to solve it but i could not.
1.Selected bank and branch is loaded accordingly
i search for a branch
and again changed the bank
the searched branch is not getting cleard.

Please help me to reset

this very emergency

this is my code

$col = array();
$col["title"] = "BANK NAME"; // caption of column
$col["name"] = "bankid";
$col["dbname"] = "bankid";
$col["width"] = "40"; // grid column name, must be exactly same as returned column-name from sql (tablefield or field-alias)
$col["editable"] = true;
$col["width"] = "200";
$col["align"] = "left";
$col["search"] = true;
$col["editable"] = true;
$col["isnum"] = true;
$col["isnull"] = true;
$col["edittype"] = "select"; // render as select
# fetch data from database, with alias k for key, v for value
$banktb='"hrms_bankmast"';
$bankid='"bankid"';
$bankname='"bankname"';
$branchtb='"hrms_branchmast"';
$branchid='"branchid"';
$branchname='"branchname"';
$str = $grid->get_dropdown_values("select $bankid as k, $bankname as v from ADMIN.$banktb ");
$col["editoptions"] = array(
"value"=>":;".$str,
"onchange" => array("sql"=>"select distinct $branchid as k, $branchname as v from ADMIN.$branchtb WHERE $bankid = '{bankid}'",
// "search_on"=>$branchid,
// "callback" => "update_bank"
"update_field" =>"branchid"
)
);
$col["editoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_bank('{$col["name"]}'); },550); }";

$col["formatter"] = "select";
$col["stype"] = "select";
$col["searchoptions"] = array("value" => ":;".$str);
$col["searchoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_bank('gs_{$col["name"]}'); },550); }";
$col["formoptions"] = array("rowpos"=>"11", "colpos"=>"1") ;
$col["show"] = array("list"=>false,"edit"=>true,"add"=>true);
$cols[] = $col;

$col = array();
$col["title"] = "BRANCH NAME"; // caption of column
$col["name"] = "branchid";
$col["dbname"] = 'ADMIN.hrms_branchmast.branchid';
$col["width"] = "40"; // grid column name, must be exactly same as returned column-name from sql (tablefield or field-alias)
$col["align"] = "left";
$col["search"] = true;
$col["editable"] = true;
$branchtb='"hrms_branchmast"';
$branchid='"branchid"';
$branchname='"branchname"';
$bankid='"bankid"';
$banktb='"hrms_bankmast"';
$bankid='"bankid"';
$bankname='"bankname"';
$col["isnum"] = true;
$col["isnull"] = true;
$col["edittype"] = "select"; // render as select

$str = $grid->get_dropdown_values("select distinct $branchid as k, $branchname as v from ADMIN.$branchtb
inner join ADMIN.$banktb on ADMIN.$banktb.$bankid= ADMIN.$branchtb.$bankid ");
/* } */
$col["editoptions"] = array(
"value"=>":;".$str,
"onchange" => array("sql"=>"select * from ADMIN.$branchtb WHERE $branchid = '{branchid}'",

"callback" => "update_fieldsbr"));
$col["editoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_branch('{$col["name"]}'); },550); }";
$col["formatter"] = "select";
$col["stype"] = "select";
$col["searchoptions"] = array("value" => ":;".$str);
$col["searchoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_branch('gs_{$col["name"]}'); },550); }";
$col["hidden"] = true;
$col["formoptions"] = array("rowpos"=>"11", "colpos"=>"2")