I would like to limit the size of a drop down menu with data from a foreign key (table) to a more workable size so I would like to add a where clause in the following code, does it exist or is this possible?
In My view.html.php of the form:
$model_company_id = CkJModel::getInstance('Contacts_1', 'GuidemanModel');
$model_company_id->addGroupOrder("a.name");
$lists = $model_company_id->getItems();
I would like to add a where statement to limit the company names of the country of the user. is there a way to do it?
