I have a question regarding OnFilterRecord event.
I know how to set one criteria, for example
Acceptable:=DataSet.FieldByName('MasterTableId').AsInteger=MasterTable.FieldByName('MasterTableId').AsInteger;
But, how to set several filtering criteria at once? What if I have if...and...and...?
For Example, If filtering criteria is:
1. DataSet.FieldByName('Field1').AsInteger=MasterTable.FieldByName('FieldA').AsInteger;
AND
2. DataSet.FieldByName('Field2').AsInteger=MasterTable.FieldByName('FieldB').AsInteger;