If I type in a product number, the query returns a table with information about the product.
The problem is this:
If my products list has upto around 10000 lines, the query works fine. However, when I exceed this number, the query returns no records. I need the query to be able to search up to 60000 lines!! I have not set a limit to the amount of records that can be returned.