Right, in this case vp_csiteid is the child record -- when I say vp_csiteid=lcsiteid I get one record in the result set only.
So, then if this is my problem, How do I say to the Bizobj, I want all csiteid's that are in the filtered set for lcdistid?????????
I have gone over my bizobj's and my views all bizobj's are defined the same way with 2 data environments -- v_table and v_table_ro
where v_table has a filter set vp_ctableid = ctableid
and v_table_ro has a filter to the parent vp_cparentid = cparentid
So it has to be what I'm saying in the init.
Thanks!
<i><font color="#663300"><i><font color="#663300">Here is my Init code for a child form:
LPARAMETER lcdistid,lcdistrict,lcsiteid,lcall
*!* gasb_lusite_form.init()
LOCAL lnFileStatus
lnFileStatus = dodefault()
IF EMPTY(lcall)
vp_cdistid = lcdistid
thisform.lblDist.caption = ALLTRIM(lcdistrict)
thisform.abo_district.cdistid = lcdistid
vp_csiteid=lcsiteid
thisform.abo_site.csiteid = lcsiteid
thisform.anavbuttons.visible=.F.
requery('v_site_dist_ro')
thisform.abo_site.requery()
thisform.refresh()
ELSE
thisform.anavbuttons.visible=.T.
vp_cdistid = lcdistid
thisform.lblDist.caption = ALLTRIM(lcdistrict)
thisform.abo_district.cdistid = lcdistid
requery('v_site_dist_ro')
thisform.requery()
thisform.refresh()
ENDIF
does your view definition include vp_csiteid in the FILTER? I presume it must do and yet there is no definition provided for vp_csiteid in your setup code after ELSE that is why the view is asking for it when you run the form. - it is defined if lcall is EMPTY only.</font></i>
Lynette
ltillner AT yahoo .DO.T com
©2002 Lynette Tillner |
