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.
Peter Brama
West Pointe Enterprises
VFP is getting easier but STILL alot to learn!!