1 Reply Latest reply on Dec 29, 2006 9:27 PM by azadisaryev

    query help

    Keith444
      Hi i have the following tables below.

      Manufactures_Table
      Category_Table
      Models_Table
      Model_To_Products_Table
      Products_Table

      i have a selection area at www.southerncooling.com/Parts.cfm

      but i need the results page to show like this

      Manufactures_Table.Man_Name
      Category_Table.Cat_Name
      Products_Table.Part_No

      so i need to group the output by Manufactures_Table.Man_Name first
      then Category_Table.Cat_Name then list all the Products_Table.Part_No for each

      can someone helpl me with the query, i think i have my tables correct here is a excel sheet with my table layout
      http://www.southerncooling.com/Book1.xls
        • 1. Re: query help
          azadisaryev Level 1
          how is your Models_Table linked to Category_Table and Category_Table linked to Manufactures-Table? All I can see in your xls file is a Models_Table that has Man_Model and Cat_Model fileds. Are these fileds the ids of manufacture and category?