AnsweredAssumed Answered

Using the lookup function in a plumbing supply invoice program with over 30,000 products items.

Question asked by rtsue on Nov 3, 2009
Latest reply on Nov 3, 2009 by casey777

Title

Using the lookup function in a plumbing supply invoice program with over 30,000 products items.

Post

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?.

Outcomes