I have a DataWindow object with these three columns:
- status - which is a checkbox
- criteria - which is a dropdownDW
- another
When status is 1 (checked) then criteria.Protect='0'
. If the user chooses from the criteria list "another criteria", then another.Protect='0'
and the user can write whatever he wants.
The problem is when the user changes his mind and uncheck the status. The criteria and the another column have the last values he chose/wrote before. How can I reset the dropdownDW or how can I have the default values back?
In the itemchange event I have this:
choose case dwo.name
case "status"
if data ='0' then
dw_list.modify("criteria.Protect='1'")
dw_list.modify("another.Protect='1'")
else
dw_list.modify("criteria.Protect='0'")
end if