Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2013

    Unanswered: Building a query

    Hi to all,

    This is my first post on this forum. I am looking for some guidance on how to approach the following. I have a MS Access Db with names of "parts." an x number of parts make a product.

    How would I query 10 different parts. Something like:

    Select one piece of these parts and show it as Product_1

    Does it make sense.
    Please any ideas are much appreciated. I am not an access expert (as you can see) but i can find my way around it.



  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    well yo'd need a gozinto list (table
    ie partxyz is used in part123
    3 off partxyz is used in part 123
    usually you'd do that as a junction / intersection table

    from my days at Uni I seem to remember that there should be be no more than 5 levels per final assembly, but I always doubted that

    effectivley what you want is a variant of this
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Dec 2013
    thank you for the reply. I will look into your suggestion. At the moment I have figured out how to query my parts and save the query as the product name. When I run the query already knows what the parts are. Thanks. I am sure I will be screaming for help as I go along. Cheers.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts