Drop Down List Based on Data Entry.
I have set up an Invoice, Products, and Line Item link.
Our product inventory is extremely large so there is no way that anyone will be able to memorize product keys to populate the item description field. I need a way in which someone can start entering the product description and a list pops up that has everything listed that he can pick from that then populates the item #, price, etc. I also want to be able to keep the option to enter a product by number.
For example, if an item's name is "Fender Twin Reverb", when I start to type F..e...n... it narrows down the list to products with Fender, then Fender Twin, then Fender Twin Reverb.
Hopefully makes sense...and hopefully there's a way to do it =)