Filtering 3 tables on the same criteria

[woodyinoz]

Hi all,

I have 3 tables on 3 seperate pages on a form. Each table contains a contract and a structure number but none of these are unique as each occur multiple times in each table.

I want to one a single filter on all three tables where the user can filter contract no and structure no and each table will show only the information for those selected.

Any ideas anyone?

Thanks,

Woody.

 

[Guest_imported]

Ok. One step at a time. Presumably you want the user to specify the contract number. If the user enters this into an unbound field on the form, you could attach code to the newValue method of the field like:

method newValue(var eventInfo Event)
var
dynFilter dynArray string
endvar
if eventInfo.reason() = EditValue then
msgInfo("", "Changing to " + self.value)
;assume fieldname is ContractNo
dynFilter["ContractNo"] = self.value
;assume the tableframe is called table1
table1.setGenFilter(dynFilter)
endif
endmethod

If this starts to get you where you want to go, the concept can be expanded. NB: there may be performance issues associated with setGenFilter.