WHat is the best way to do this?
I am working on essentially an inventory control application. But we actually manufacture all of the items. When the plant finishes building an item they need to input it into the data base.
The plant manufactures many of the same items over and over again. We wanted to have a data base of items that the plant manufactures and this way when they finish a product it is much easier, all they need to do is tie a serial number to the new item (record).
Problem is, with thousands of items how can i make it easy for someone to select a single item?
What we were going to do is maintain a database of items through a separate form from the one that the plant fills in. The plant form will use look up fields to get the data for the items from the other form. Trouble is the item name look up field will have thousands of items, not a good solution! I want to do some sort of search but don't know how i will do this. The items can be broken into categories but this will not make the list small enough to deal with plus the plant will not know the categories, all they will know is the item name. Because they only know the item name they will need to do a seach based only on the item name. How can i do this?
Ideally it would be one of those searches where as you type a word it pulls up the matches right below where you are typing. Somehow i doubt zoho can do this.
In reading many posts it sounds like this is in the creator road map, are we talking years or months before it may be available?
Thanks for any help or direction.