I recreated the view using Composite Table 9.0B\*SR Trans w AR, OE Hst Head, IC and it loads in 3 minutes vs 45 minutes using OrderEntry 8.0A-8.1C\OE Hist Detail /w Header. When I remove the references to related column {category} from the filter, it loads in about 3 minutes instead of 45 minutes. I need to filter by {category}, however, so I guess I'll use the composite table since it doesn't slow it down when filtering by {category}.

Another problem I'm having that I can't figure out is with this filter:

AND (
{Date} >= QUERYDATE("Enter START Date:", TODAY()),
{Date} <= QUERYDATE("Enter END Date:", TODAY()),
Left({Salesperson},5) =Left(QueryString("Enter LINDSY, KINGSN, LONDON", ""),5),
{Qty} <> 0,
{Amt} <> 0,
{Category} <> " BE",
{Category} <> " MC ",
{Category} <> "RCO",
{Category} <> "RCA",
{Category} <> " SH",
{Category} <> " ZZ",
{Item #} <> "Tax0",
{Item #} <> "Tax1",
{Item #} <> "Tax2",
{Item #} <> "Tax3",
{Item #} <> "Tax4",
{Item #} <> "MIS1",
{Item #} <> "MIS2",
{Item #} <> "MIS3",
{Item #} <> "MIS4",
{Item #} <> "MIS5",
{Item #} <> "MIS6"
)

For some reason, when we enter the start date, end date and salesperson, the view loads but immediately pops up and asks for the start date, end date and salesperson AGAIN. After the second round, it loads correctly. Any idea how I can stop it from asking the 2nd time for the start date, end date and salesperson?