Using the lookup function in a plumbing supply invoice program with over 30,000 products items.
I'm preparing to develop an invoicing system for my plumbing supply company. I have over 30,000 items and the number is growing rapidly everyday. The item code for most items are very similiar because of the nature of the items, for example a very simple case for a 1 1/4" Tee is available in many types of materials such as brass, black iron, PVC, copper, etc. The code for these would be 114TBR,114TB,114TP,114TC,etc. with significantly different prices. I would need enter these into the invoicing system as a customer is reading off a list of materials (very quickly) without having to write down the item then entering the item later. I was hoping have an accurate lookup based on a code that I don't have to memorize (30,000 +) items. Will this work in Filemaker 10?.