Need query to look up multiple part no.'s R2001-01, R2001-02,...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have create a product database. Each product has several components listed.
i will use the query to look up a component (part no.). i have listed some
parts singular (R2001-01) per cell, and others with multiple part
no.(R2001-02, R2001-03, P5369-45...) per cell. My query will find the single
but not the any of the multiple. how can i set up the query to look for one
of the part no.'s that are combined with others?
 
This is a data setup issue. You should list each product-component combo on
a different line. So your data should look like this:

Product Component
A1 R2001-02
A1 R2001-3
A1 P5369-45
A2 R2001-3
A3 R2001-02

You may want to review the Access tutorials on relational databases and
general data setup.
 
Back
Top