Cacher is the code snippet organizer for pro developers

sql = ... 
(SELECT CONCAT_WS(' ', comShortName, comCommercialName)comCommercialName FROM tblCompany WHERE comID = PREFIXCompanyID) AS branchName

5. Filter Settings
// Branches List
$query_branches = mysql_query("SELECT FROM tblCompany");
$num_rows_branches = mysql_num_rows($query_branches);
$fill_from_array_branches = array();
for($i = 1; $i <= $num_rows_branches; $i++)
{
$row_branches = mysql_fetch_assoc($query_branches);
$fill_from_array_branches[$row_branches['comID']] = $row_branches['comCommercialName'];
}
//*** Branches List END

$filtering_fields = array(
"$FieldBranchName" => array("type" => "dropdownlist", "table" => "TABLE_NAME", "field" => "PREFIXCompanyID", "show_operator" => "false", "default_operator" => "=", "case_sensitive" => "false", "comparison_type" => "string", "width" => "150px", "on_js_event" => "", 'multiple' => false, 'condition' => "", 'source' => $fill_from_array_branches),
);
6. View Mode Settings:
"branchName" =>array("header"=>"$FieldBranchName", "type"=>"label_wtooltip", "align"=>"center", "header_tooltip"=>"", "case"=>"normal"),

7. Add/Edit/Details Mode Settings
"PREFIXCompanyID" => array("header" => "$FieldBranchName ", "type" => "foreign_key", "req_type" => "", "width" => "210px", "title" => "", "readonly" => "false", "default" => "$_SESSION[CompanyID]", "unique" => "false", "unique_condition" => "", "visible" => "true", "showcount" => "true"),

Foreign Keys 
$foreign_keys = array(
"PREFIXCompanyID"=>array("table"=>"tblCompany", "field_key"=>"comID", "field_name"=>"comCommercialName", "view_type"=>"dropdownlist", "condition"=>"", "order_by_field"=>"", "order_type"=>"DESC", "on_js_event"=>""),
);