Classic example. i have table Products and I have table Orders. They are connected with Lookup. When i add products to order on the form, I can expand list of Products and select one.
now I want that this list of products get smaller as i start typing. I have for example 1000 products and search though them by scrolling dropdown list is complicated. But I know basic product names that could help.
What is the solution in such a case?