Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2011
    Posts
    5

    Unanswered: Filtering a Query based on 3 tables

    Hi All,

    I am trying to create a query that will display the information that is common between 3 tables based on one field.

    I have the following tables:

    Material_Inventory:
    SAP_No [text]
    D_DT [text]
    Description [text]
    Units [text]
    Unit_Cost [Currency]
    Total_Quantity [Number]

    BOM:
    Name [Text]
    Quantity [Number]

    Wood_List:
    SAP_No [Text]
    Description [Text]

    Material_Inventory is a database containing all items.
    The user selects items from Material_Inventory and gives the items quantities e.g. Description: pole, Quantity: 10
    Wood_List contains only some items of Material_Inventory. BOM might/might not have items in common with Wood_List.

    I want the query to link the 3 tables and show only the items that are common between the 3 tables. Basically Wood_List filters BOM which filters Material_Inventory.

    Or alternatively I want Wood_List to filter BOM and use Material_Inventory to display Total_Quantity of the item in Wood_List.

    Thanks!

  2. #2
    Join Date
    Oct 2011
    Posts
    5

    Red face

    Sorry my bad... BOM didn't have anything from the Wood_List table.... been a long day

Tags for this Thread

Posting Permissions

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