Find content
Not Telling
Thanks to all, as set_relation don't work when you use a table from other DB, I used this code to make the dropdown.
$crud = new grocery_CRUD();
$crud->set_table('testtable');
$crud->set_subject('TEST');
$crud->columns('id_sup',...............................................);
$DB1 = $this->load->database('otherdb', TRUE);
$query=$DB1->query("SELECT id, CONCAT (id,' - ',name) as fullname FROM supertabla WHERE activo=1 ORDER BY name ASC;");
$arr_ids = array();
foreach ($query->result() as $row)
{
$arr_ids[$row->id]=$row->fullname;
}
$crud->field_type('id_sup','dropdown', $arr_ids);
