[RBG7-L] - Re: View Speed

[ttc . inc]

 

 

Sel MAX(Breakdat) into varname from master where Custnub2 = .vcust

 

should work much faster, especially if you have an index on

Custnub2.  Have an exit EEP from the customer ID field look up

the value as such.

 

 

-------------- Original message --------------

Is there any way to speed up the following view or a different method to be recommended for getting this information. I am trying to display the date of the last time we handled a customers business in a form as we enter the customer number in the form and begin a new record.

 

(custnub2, Breakdate)

Sel Custnub2, max Breakdat

from master

group by custnub2

 

Thanks for any help.

 

Stephen Breen

CDI Services, Inc.

3610 Deahl Court

P.O. Box 3838 South Bend, IN 46628

574-271-2027 Ext: 200

Fax 574-247-4638

Fax: 574-247-4631

Email: [EMAIL PROTECTED]

Web Site www.911roadrepair.com

Pager 800-668-8023

Cell 574-339-2356