>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?
Steve Gibson