4 Replies Latest reply on Jan 16, 2007 8:29 PM by JohnGree

    Results Output

    JohnGree
      Hi i have a results page which i need a little help with,

      if you look at http://www.southerncooling.com/ProductResults1.cfm

      this show results that match what the user selected which is what i want

      but i want to display all the range and models for the product as shown here
      http://www.southerncooling.com/ProductResults.cfm

      ie if a user selects EXD-170 it needs to show products like this

      505350 Tank Beige EXH-130, 150, 170, 190, 210, EXD-150, 170

      showing the other models aswell, i have tried outer joins but still no luck

      any ideas what i need to do

      many thanks

      John