Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011
    Posts
    4

    Unanswered: Help creating outer join query

    So I am creating a database (Access 2010) that shows all the parts my company produces for various customers. Each part we produce will have a unique combination of Customer Number (number the company assigns internally), Part number (number customer gives us), and revision number (number customer gives us). I set those three fields as a composite key for the PartTable.

    Some (but not all) of these parts will have a special operation performed on it (let's call it Beveling). On the PartTable, I have a Yes/No checkbox for a Bevel field indicating whether the part has this operation performed. Then I set up a query to filter only parts with Bevel = Yes.

    From this query, I set up BevelInfoTable. This is to display the details of beveling operations. Some parts may multiple beveling operations performed on it.

    I tried to create a outer join query that displays fields from the PartTable and fields from the BevelInfoTable. However, it seems to use the Autonumber ID and places the beveling info with parts with the same Autonumber ID (instead of with the same Part #).

    What am I doing wrong? Is there a simplier or more efficient way of setting this up?

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    In your query, it sounds like you are linking with the "Autonumber ID" field instead of the "Part #" field. But it's pretty hard to work this out with out further references, such as the table structure and the query design.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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