Special Filter on Form

ta5

Hi
Is it possible to have a list form which shows (for example) all customers having a ZIP-Code of xyz --OR-- having the Blocked field set to yes.
I think this is not possible with filters only.
Many thanks in advance
H

s.delikostov

You can MARK the records of the table that you want to see, and set MARKEDONLY filter.

ta5

Thank you very much. Is the marking done on the OnOpenForm()-Trigger?
Regards
H

s.delikostov

You can make the mark in OnOpenForm.
You can also make it before run the form:

IF Customer.FIND('-') THEN REPEAT
IF (Customer."Post Code" = '1000') OR (Customer.Blocked <> Customer.Blocked::" ") THEN
Customer.MARK(TRUE);
UNTIL Customer.NEXT = 0;

Customer.MARKEDONLY(TRUE);

FORM.RUN(0,Customer);

ta5

Looks cool? A (hopefully last question):
How would the code look on the OnInit-Trigger?

s.delikostov

OnOpenForm:

IF FIND('-') THEN REPEAT
IF ("Post Code" = '1000') OR (Blocked <> Blocked::" ") THEN
MARK(TRUE);
UNTIL NEXT = 0;
MARKEDONLY(TRUE);