>Thanks Hilmar,
>
>This is what I understood from your resonse. Does this makes sense?
>
>WITH THISFORM
>.grdList.colcWorkOrderNo.AddObject("cbocWorkOrderNo", "combobox")
>.grdList.colcWorkOrderNo.CurrentControl = "cbocWorkOrderNo"
>.grdList.colcWorkOrderNo.cbocWorkOrderNo.RowSourceType=3
>.grdList.colcWorkOrderNo.cbocWorkOrderNo.RowSource="SELECT SALEORDER_ITEMS.cWorkOrderNo,LINE.cCode FROM SALEORDER_ITEMS INNER JOIN LINE ON SALEORDER_ITEMS.cLineID=LINE.ID WHERE NOT INLIST(ALLTRIM(cStatus),'Cancelled','Closed') AND NOT EMPTY(cWorkOrderNo) ORDER BY 2,1 INTO CURSOR tmpProduction"
>.grdList.colcWorkOrderNo.Sparse = .F.
>ENDWITH
I think yes. I am more accustomed to doing this in the form designer, though, so I am not sure whether everything is OK or not. Just try whether it works.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
