I my main table I publish a list of products with the relative suppliers (about 60.000 unique companies) as a lookup from the suppliers table.
Unfortunately, the normal search does not find any result if for instance I try to filter my products list by supplier.
Moreover, the advanced search allows to select the supply company only through a drop-box menu and not a free-text field. Considering the number of records in the suppliers table, it is very difficult and time consuming to go through all the company names, although in alphabetical order.
Does anybody know how to solve this problem?
