Xavier Ekka asked 11 years ago
How I can Add Records to a table which picks data from one other table.
For example there are two tables, emp_table and salary_table.
When i add a new record in salary_table the pop_up FORM should have a combo box listing all the employee from the emp_table.
1 Answers
Abu Ghufran answered 11 years ago
Please refer the demos/appearence/dropdown.php
It lookup client name from clients table.
$col = array();
$col["name"] = "client_id";
…
$col["edittype"] = "select"; // render as select
# fetch data from database, with alias k for key, v for value
$str = $g->get_dropdown_values("select distinct client_id as k, name as v from clients");
$col["editoptions"] = array("value"=>":;".$str);
$col["formatter"] = "select"; // display label, not value
…
$cols[] = $col;
Your Answer
