I have a database that houses parts currently in inventory. The parts table itself only has SKU, Description, Supplier, and Suppliers PN in the table. There is also a metadata table that houses additional information about parts. The metadata table has PartID, ParameterName, and ParameterValue for fields. The goal of this is to be able to store parts with drastic different information yet be able to search effectively for them. For instance, one part may be a bolt. It has important data such as length-under-head, thread size, material type, etc. Another part may be an electronic resistor which has a package, tolerance, and resistance.
I need to be able to search by this metadata for a part that matches values in 1 or more of these fields (i.e. a resistor with a 0603 package and a resistance of 330 ohms). Yet, the only way I could think of doing it is searching the metadata table separately for each field value and then seeing which partIDs are on both lists. Anyone got a better way? Nate L. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]
