ok lets start at the beginning as i have been on this for
about 3 weeks now!!!
if you look at
http://www.southerncooling.com/Parts.cfm
then use the selection BRAND, CATEGORY, MODEL
THE RESULTS PAGE SHOULD SHOW ALL PRODUCTS THAT MATCH THE
MODEL SELECTED, AND THEN SHOW NEXT TO THE PRODUCTS THE RANGE NAME
FOLLOWED BY THE MODELS NUMBERS THAT THE PRODUCT IS ACCOCIATED WITH.
IE
884443 // EA-34, 45, 56 EF-34,45,46
THEN HAVE THEM GROUPED INTO CATEGORYS FROM THE CATEGORIES
TABLE
HOPE THIS MAKES SENSE
i have the following tables
**PRODUCTS_TABLE**
Products_ID (UNIQUE)
Part_No
Discription
**MANUFACTURES_TABLE**
Man_ID
Man_Name
**PRODUCT_TO_MANUFAC_TABLE**
PM_Product_ID
PM_Man_ID
**PRODUCT_TO_CATEGORY_TABLE**
PC_Product_ID
PC_Category_ID
**RANGE_TABLE**
Range_ID (UNIQUE)
Range_Name
Man_Range
Range_ID
**MODEL_TABLE**
Model_ID (UNIQUE)
Man_Model
Range_Model
Model_Name
**MODEL_PROD_TABLE**
Model_Prods_ID (UNIQUE)
Prod_ID34
Model_ID34
Range_Model
Info
and this is the full output i need
<table width="100%" border="0">
<cfoutput query="Products" group="Cat_Name">
<tr>
<td bgcolor="B02300"
class="MainMidWhite"><strong>#Products.Cat_Name#</strong></td>
</tr>
<tr>
<td><table width="100%" border="0">
<tr>
<td></td>
<td bgcolor="##000000" class="fixed5"><div
align="left" class="MainMidWhite"><strong>Part No
</strong></div></td>
<td bgcolor="##000000"><div align="left"
class="MainMidWhite"><strong>Discription</strong></div></td>
<td bgcolor="##000000"
class="fixed5"> </td>
</tr>
<cfoutput>
<cfset bgcolor="##BBCCE1">
<tr>
<td width="30"></td>
<td bgcolor="#bgcolor#"
class="fixed5">#Products.Part_No#</td>
<td bgcolor="#bgcolor#"><div align="left"
class="Main1Black">#Products.Discription#
</div></td>
<td bgcolor="#bgcolor#" class="fixed5"><div
align="center"><span
class="style3">#Products.Range_Name#-#Products.Model_Name#,</span>
</div></td>
</tr>
</cfoutput>
</table></td>
</tr>
</cfoutput>
</table>