Link to home
Start Free TrialLog in
Avatar of srinib
srinib

asked on

Drop Down Datawindow Filter

Hi,

I have a drop down datawindow which needs to be filtered based on selection.
To be more specific, based on broker id child datawindow needs to be populated. If i select broker 'A' then child datawindow should filter on broker 'A'.

Currently if i filter a child dw then it is effecting all other rows also.
Is there any solution except populating in drop down list .

Thanks
Srinib
Avatar of gajender_99
gajender_99


in the event  itemchanged  for your broker
just write these code, these are example if you need any help let me know

String    sColumnName

sColumnName = THIS.GetColumnName ()

IF sColumnName = "column name" THEN

DataWindowChild   dwchild_1

dw_client.GetChild ("coulmn name where the is dddw ", dwchild_1)

dwchild_1.SetTransObject (SQLCA)
dwchild_1.Retrieve ()
dwchild_1.setfilter("Condition")
dwchild_1.filter()

End if
Avatar of srinib

ASKER

Gajender,

Your code seems, it will filter dropdown dw in all the rows which i don't want.  

Bottom line is....
I have broker ids, and each broker will have mulitiple acccounts.
If i select Broker 'A' in first row then i should be able to filter the dddw based on this broker id.
Again if i select broker 'B' in second row then i should be able to filter based on borker 'B'.
But whatever i have selected in first row that should remain same.
Currently it is filtering in all the rows.

Thanks for your valuable time
Srinib
ASKER CERTIFIED SOLUTION
Avatar of falvaro3
falvaro3

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial