Question, I have always used views to kind of speed up everything but sometimes that seems to provide the desired result.
I have a view based on 3 tables. All linking columns are indexed. Record set of about 150,000. EDIT ALL FROM View WHERE Column1 = Query1 --This gives results in < 1 Second EDIT ALL FROM View WHERE Column2 = Query2 --This also gives results in < 1 Second EDIT ALL FROM View WHERE Column1 = Query1 AND Column2 = Query2 --This gives results in about 10 Seconds Somehow I figured that the final query would be just as quick as the first two but maybe I'm doing it wrong. Also, somehow after the last update (707) my help files have disappeared in both 7.5 and 7.1 Jan
