Peter,

Create a parameterized view in teh database wiht the fllowing set up.

SELECT partnername, partnerid FROM partner ;
 WHERE firmid=lcfirmid into cursor cur1 order by 1

Then in the requery method of the partner combo put this code;

* Assumes the firmID is column 2 of the firm combo
LOCAL lcFirmID
lcFirmId = Thisform.cboFirm.List(Thisform.cboFirm.ListItem,2)
Requery("TheNameOfTheView")

From the interactivechange event of the firm combo call teh partnercobmo's requery method.