Hello
I have MySQL tables that have several foreign keys already defined. Is there a way to display/recognize these back end drop down fields in the front-end grid easily and automatically without having to create/define them in the PHP front-end file as you have done in the dropdown.php file. Or is that the only way?
thanks
Tony
2 Answers
I’ve reviewed your requirement and easy way could be like in demos/promo/index.php demo:
$col = array();
$col[“title”] = “Company Name”;
$col[“name”] = “company_name”;
$col[“width”] = “50”;
$col[“editable”] = false;
$col[“search”] = true;
$col[“edittype”] = “lookup”;
$col[“editoptions”] = array(“table”=>”suppliers”, “id”=>”company_name”, “label”=>”company_name”);
$cols[] = $col;
Your Answer