Filtering on the combined data from different fileds

mabl4367

What is the best way to filter, say "Sales header" on:

(Sell-to Customer No.=A and Bill-to Customer No.=B) or
(Sell-to Customer No.=C and Bill-to Customer No.=D) or
(Sell-to Customer No.=E and Bill-to Customer No.=F)

This is not the same as:
((Sell-to Customer No.=A) or
(Sell-to Customer No.=C) or
(Sell-to Customer No.=E)) AND
((Bill-to Customer No.=B) or
(Bill-to Customer No.=D) or
(Bill-to Customer No.=F) or
witch is easy to do.


Do I have to set one filter at a time, loop through the set for each filter and mark records or put them into a temp table or is there a better way?

matttrax

mabl4367 wrote:

Do I have to set one filter at a time, loop through the set for each filter and mark records or put them into a temp table or is there a better way?

You have answered you own question. I believe temp table is faster than marking records, but I'm not for sure.

mabl4367

Ok thanks!