Dropdowndatawindow within datawindow

[061178]

Hi there,

I have a dddw in a dw and I have successfully retrieved a value into this dropdown depending on a retrieval argument (using getchild etc). Now all I would like to do is set the value of this field (which is a dropdown) to be the only value that is retrieved. Basically, this field is for display purposes only and it retrieves a desc from a different table (instead of just displaying a meaningless code). Now all I would like to do is set this field to the 1st row retrieved in the dropdown. Curently, user must click on the dropdwon and choose the value, but only 1 value will always be retrieved and I would like to just set it to this 1 value. Can anyone help. Thanks in advance.

 

[brokenbone]

Hi!

You could just disable the field for editing (using AllowEdit property in script or just deselcting Allow Editing on the properties tab for that field on DW) and set the right value (using Find and SetRow functions).

If you would like to leave the field enabled for user to select a value, you can do one of these things:
1st: you can change the SQL in DDDW and retrieve it again (using getchild)
2nd: you can just filter the retireved rows from that DDDW
3rd: you can change the Lines property of DDDW to 1, if the right value is allways the 1st row.