Hi all,
I've got a datawindow with 3 DropDownDW's. I can't retrieve the drop-downs until after the parent dw is retrieved. The Auto Retrieve is checked OFF on all three . In the parent DW's RetrieveEnd event I've got the following code:
ll_TmdeID = this.GetItemNumber( 1, "tmde_id")
this.GetChild('tmde_attachments', ldwc_tmde_doc)
ldwc_tmde_doc.SetTransObject(sqlca)
ldwc_tmde_doc.Retrieve(ll_TmdeID)
ll_EquipID = this.GetItemNumber(1,"equipment_id")
this.GetChild('equip_attachments', ldwc_equip_doc)
ldwc_equip_doc.SetTransObject(sqlca)
ldwc_equip_doc.Retrieve(ll_EquipId)
ls_cal_procedure = this.GetItemString( 1, "tmde_cal_procedure")
this.GetChild('attachments', ldwc_procedure_doc)
ldwc_procedure_doc.SetTransObject(sqlca)
ldwc_procedure_doc.Retrieve(ls_cal_procedure)
ldwc_equip_doc and ldw_procedure_doc work fine. But for some reason, ldw_tmde_doc shows the doc_id field instead of the FileName, even though FileName is the display column. The doc_id field isn't even visible in the dddw object. If I click on the drop-down arrow the FileName displays correctly. I can select it, then the ldw_tmde_doc object shows the FileName.
I tried adding ldwc_tmde_doc.SetRow(1), and ldwc_tmde_doc.SelectRow(1,TRUE)... no luck.
Any idea why this works in 2 of 3 DDDW's?
~~~Tracy
You were right, I had to set the Data Column in the DW Edit style to ID, not doc_id.
Many Thanks!!!