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