AnsweredAssumed Answered

Searching Multiple Lists

Question asked by Stephen Lapic on Jun 9, 2011
Latest reply on Jun 23, 2011 by Jeff Gherardi

If I have three different types of parts - A, B, & C -  and on their unique file cards they each draw from a list of Vendors - Vendors for A, Vendors for B, & Vendors for C.  Each list could have between 3 and 10 or so vendors.  Some of those vendors are unique to one part but some can be suppliers for two or all three parts.  I'm creating a search card just for Sales and Pruchasing so they can search by PO number or drawing number but they also want to view what part(s) an individual vendor supplies regardless of PO or anything else.  I can't use any of the three vendor lists since they don't cover them all.  Do I need to create another list combining them all?  The problem with creating a combined list is that if there is a change to one of the original three then I would have to duplicate that work in the fourth - more importantly rember to do it in the forth list. (By the way, there are a lot more than just part parts and lists this was just an example)

 

Any thoughts?

Outcomes