I am trying to make a filter with 2 comboxes and a 2 cursors for example the cursor 1 is the rowsource of the combo 1, the cursor 2 is the rowsorce of the combo 2, i want to make a filter in the combo 2 with the combo 1 value. for example if the combo 1 value is 'city 1' so the combo 2 display only the data with a 'city 1' relation. i can do when i am making a new register but when i am trying to modify the register created with this method sometimes do but sometimes display my combo 2 clear without registers. this is a example of my code:
&&This is the gotfocus method of my combo2:
if !empty(combo1.value)
set exact off
set near on
select subclases1
go top
set filter to subclases1.clase=k_clase
locate for subclases1.subclase=val(thisform.nsubclase)
this.value=thisform.nsubclase
else
select subclases1
set filter to subclases1.clase=k_clase
endif
set exact on
set near on
thisform.refresh
i can make the filter only is i am makin a new register, but modifying not.