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?

That does the trick, Thanks for the excellent and FAST support.!