>>>Sorry if this has already been covered, but can you just keep the CustID and PoNum indexes, and do:
>>>
>>>SELECT * FROM PastInvoices WHERE CustID = ?lcCustID AND PoNum = ?lcPoNum
>>
>>That is basically what I am doing, except for the '?' in front of the variables. What does the '?' do?
>
>Oh, sorry, I use those in parameterized views. Anyway, when you way that is the way you are doing it, doesn't that mean you can get rid of the CustID+PoNum index?
Yes, I will get rid of any SEEKs and use a SELECT instead.
Thanks and have a good weekend,
Steve Gibson