COPYFILTER Function (Record)
Copies the filter that has been set for one field and applies it to another field.
The record from which to copy the filter.
The field from which the filter will be copied.
The record and field to which you want to apply the copied filter.
This example requires that you create a Record variable for the Customer table named Customer and an Integer variable named Count.
Customer.SETFILTER("No.", '<1000'); Customer.COPYFILTER("No.", Vendor."No."); . . Count := Vendor.COUNT;
The filter set for Customer."No." is copied and applied to Vendor."No.". This affects the result of the, which counts how many vendors have a number less than 1000.