- $sql = "SELECT account_code, concat(account_code, ' - ', account_name) as account_name FROM ".TB_PREF."chart_master";
- $st .= combo_input("PARAM_$index", '', $sql, 'account_code', 'account_name',array('order'=>array('account_code')));
+ $sql = "SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id
+ FROM ".TB_PREF."chart_master chart,".TB_PREF."chart_types type WHERE chart.account_type=type.id";
+ $st .= combo_input("PARAM_$index", '', $sql, 'chart.account_code', 'chart.account_name',
+ array('format' => '_format_account','order' => array('type.id','account_code'),'async' => false,'category' => 2));