2foot9
Member
Hi List. I am trying to speed up the search time in the Credit Memo form for the pricing of returns. It seems that regardless of the amount of Header Section or QBE data entered, the search must still plough through all the record hits in the ledger before it returns the queried data. Can anyony tell me the ramifications or damage that can happen if old records are deleted from the Sales Ledger Table? Alternatively, is there a method to return faster query results if the records cannot be deleted?