Hi Abu,

I tried to update the field when the option selected from the first field. But its not working for me.

Tried:
——————————————————————-
1st Tried
——————————————————————-
$col["editoptions"] = array(
"value"=>":Select;".$str,
"onchange" => array("sql"=>"select sum(nvl(ADMIN.$runkm.$openkm,0)) as k, sum(nvl(ADMIN.$runkm.$openkm,0)) as v, from ADMIN.$runkm WHERE ADMIN.$runkm.$tyreid = '{tyreid}' and ADMIN.$runkm.$stats ='AA'",
"callback" => "update_fields"));

<script>
function update_fields(data)
{
jQuery("input[name=rethgivenkm].FormElement").val(data[0].rethgivenkm);
jQuery("input[name=rethgivenkm].editable").val(data[0].rethgivenkm);
}
</script>

——————————————————————-
2nd Tried
——————————————————————-

$col["editoptions"] = array(
"value"=>":Select;".$str,
"onchange" => array("sql"=>"select sum(nvl(ADMIN.$runkm.$openkm,0)) as k, sum(nvl(ADMIN.$runkm.$openkm,0)) as v, from ADMIN.$runkm WHERE ADMIN.$runkm.$tyreid = '{tyreid}' and ADMIN.$runkm.$stats ='AA'",
"update_field" =>"rethgivenkm"));

<script>
function update_field()
{
o = jQuery('.ui-search-toolbar select[name=rethgivenkm]').get();
o.event = 'onload'; fx_get_dropdown(o,'rethgivenkm',1);

}
</script>

————————————————————————–

Herewith i have attached the code.

$col = array();
$col["title"] = "Tyre No "; // caption of column
$col["name"] = "tyreid"; // grid column name, must be exactly same as returned column-name from sql (tablefield or field-alias)
$col["dbname"] = "tyreid"; // this is required as we need to search in name field, not id
$col["width"] = "80";
$col["align"] = "left";
$col["search"] = true;
$col["editable"] = true;
$col["edittype"] = "select"; // render as select
# fetch data from database, with alias k for key, v for value
$tyreid='"tyreid"';
$tyrename='"tyreno"';
$tts='"veh_tyredetails"';
$stats = '"status"';
$runkm='"veh_tyrerunningkm"';
$openkm='"openkm"';
$col["isnum"] = true;
$col["isnull"] = true;
$str = $g->get_dropdown_values("select $tyreid as k,$tyrename as v from ADMIN.$tts where $stats='AA'");
$col["editoptions"] = array(
"value"=>":Select;".$str,
"onchange" => array("sql"=>"select sum(nvl(ADMIN.$runkm.$openkm,0)) as k, sum(nvl(ADMIN.$runkm.$openkm,0)) as v, from ADMIN.$runkm WHERE ADMIN.$runkm.$tyreid = '{tyreid}' and ADMIN.$runkm.$stats ='AA'",
"callback" => "update_fields"));
$col["editoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_leave1('{$col["name"]}'); },200); }";

$col["stype"] = "select";

$col["searchoptions"] = array("value" => ":;".$str);
$col["searchoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_leave1('gs_{$col["name"]}'); },350); }";

$col["formatter"] = "select"; // display label, not value
$col["editrules"] = array("enable"=>false);
$col["formoptions"] = array("rowpos"=>"1", "colpos"=>"1") ;
$cols[] = $col;

$col = array();
$col["title"] = "Retreading Given Dt."; // caption of column
$col["name"] = "rethgivendt"; // grid column name, must be exactly same as returned column-name from sql (tablefield or field-alias)
$col["editable"] = true;
$col["search"] = true;
$col["isnull"] = true;
//$col["editrules"] = array("required"=>true);
$col["width"] = "60";
$col["formatter"] = "date"; // format as date
//$col["editrules"] = array("custom"=>true,"custom_func"=>"function(val,label){return my_validation(val,label);}");
$col["search"] = true;
$col["editrules"] = array("edithidden"=>true,"required"=>true);
$col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'Y-m-d');
$col["formoptions"] = array("rowpos"=>"1", "colpos"=>"2") ;
$col["show"] = array("list"=>true,"edit"=>true,"add"=>true);
$cols[] = $col;

Thank you,