Jim,

Being relatively new to VFP, I either having a "lapse of stupidity" or don't really know what I am doing with this....

I created the view using the PROJECT MANAGER, Add Local View (it's called PartnerFirm. I then used the DE on the form and added the view to the environment (it assigned Cursor5)

On the REQUERY step, I modified it slightly due to the fields location to read...

lcFirmId=Thisform.pageframe1.page1.cbFirm.List(Thisform.pageframe1.page1.cbFirm.ListItem,2)
Requery(PartnerFirm)

and I added this to the cbFirm interactivechange method...

Thisform.pageframe1.page1.clientpartnerid.requery()


If this is all correct, the next question is what should I set the properties for in the clientpartnerid combo? Especially the ROWSOURCETYPE, ROWSOURCE & BOUNDTO. Also, right now the controlsource for this is a field in the CLIENT table called client.partnerid... that should be fine, correct?

Finally, do I need to call the REQUERY when the database - Nexts or Prevs because the cbFirm changes accordingly?



Thanks again


>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.