>I have a few entities in my database application that the user chooses via a
>composite key. Example: A telephone circuit is identified by my users by the
>circuit_no and the drop_no (HEX1223WT and 002). I would like my user to open a
>window in the circuit field, display all the circuits and drops and select the
>record they want and have this data populate into my current application.
>The problem I have is when creating DropDown DataWindows (DDDW), they only
>require a single field as a key. The circuit HEX1223WT may have over 10
>different drops, the only drop I am able to pull is the first drop with the
// I assune that the drop-down is on the dw_1 datawindow
// and that the column you retrieve from the ddw is called
l_row = dwc.GetSelectedRow()
if l_row > 0 then
do your proceedings
There is a problem though. If many rows can have the same value for
this column, you cannot put this code directly in itemchanged event
handler for the main dw.
What you could do, though, is to modify the value shown in your dw, by
appending some characters to it ( also in itemchanged). Then the
itemchanged event will always work.
Before using the value shown (DB update or assigning this value to
something) you will then need to strip these additional characters.