I'm a little confused with your response. Can you explain more. Below is the view's sql.

SELECT Workorders.workordersid, Workorders.number, Workorders.quantity,;
Workorders.requestdate, Workorders.customernameview,;
Workorders.partnumberview, Workorders.requestbynotes;
FROM ;
data1!workorders;
WHERE Workorders.status = ( "O" );
AND Workorders.requestdate > ( {^2000/01/01} );
ORDER BY Workorders.requestdate, Workorders.customernameview,;
Workorders.number

DBSetProp(ThisView,"View","SendUpdates",.T.)
DBSetProp(ThisView,"View","BatchUpdateCount",1)
DBSetProp(ThisView,"View","CompareMemo",.T.)
DBSetProp(ThisView,"View","FetchAsNeeded",.F.)
DBSetProp(ThisView,"View","FetchMemo",.T.)
DBSetProp(ThisView,"View","FetchSize",100)
DBSetProp(ThisView,"View","MaxRecords",-1)
DBSetProp(ThisView,"View","Prepared",.F.)
DBSetProp(ThisView,"View","UpdateType",1)
DBSetProp(ThisView,"View","UseMemoSize",255)
DBSetProp(ThisView,"View","Tables","data1!workorders")
DBSetProp(ThisView,"View","WhereType",3)

DBSetProp(ThisView+".workordersid","Field","DataType","N(6)")
DBSetProp(ThisView+".workordersid","Field","UpdateName","data1!workorders.workordersid")
DBSetProp(ThisView+".workordersid","Field","KeyField",.T.)
DBSetProp(ThisView+".workordersid","Field","Updatable",.F.)

DBSetProp(ThisView+".number","Field","DataType","C(10)")
DBSetProp(ThisView+".number","Field","UpdateName","data1!workorders.number")
DBSetProp(ThisView+".number","Field","KeyField",.F.)
DBSetProp(ThisView+".number","Field","Updatable",.F.)

DBSetProp(ThisView+".quantity","Field","DataType","N(5)")
DBSetProp(ThisView+".quantity","Field","UpdateName","data1!workorders.quantity")
DBSetProp(ThisView+".quantity","Field","KeyField",.F.)
DBSetProp(ThisView+".quantity","Field","Updatable",.T.)

DBSetProp(ThisView+".requestdate","Field","DataType","D")
DBSetProp(ThisView+".requestdate","Field","UpdateName","data1!workorders.requestdate")
DBSetProp(ThisView+".requestdate","Field","KeyField",.F.)
DBSetProp(ThisView+".requestdate","Field","Updatable",.T.)

DBSetProp(ThisView+".customernameview","Field","DataType","C(50)")
DBSetProp(ThisView+".customernameview","Field","UpdateName","data1!workorders.customernameview")
DBSetProp(ThisView+".customernameview","Field","KeyField",.F.)
DBSetProp(ThisView+".customernameview","Field","Updatable",.F.)

DBSetProp(ThisView+".partnumberview","Field","DataType","C(30)")
DBSetProp(ThisView+".partnumberview","Field","UpdateName","data1!workorders.partnumberview")
DBSetProp(ThisView+".partnumberview","Field","KeyField",.F.)
DBSetProp(ThisView+".partnumberview","Field","Updatable",.F.)

DBSetProp(ThisView+".requestbynotes","Field","DataType","M")
DBSetProp(ThisView+".requestbynotes","Field","UpdateName","data1!workorders.requestbynotes")
DBSetProp(ThisView+".requestbynotes","Field","KeyField",.F.)
DBSetProp(ThisView+".requestbynotes","Field","Updatable",.T.)



There is an index on 'status' and 'requestdate' in the workorders table.

Thanks