Use a "keyword"  or part thereof in the Product Description search box to find specific items. (e.g. 5Z) or use a general term to browse sections (e.g. blades) or enter a "space" in the Product Description search box to list the entire catalogue.

Generic notes for the Product Groups are listed below the Product Price List Table and show when a Product Group is entered. (e.g. blades)

Click on the picture hyperlink for photograph.

Product description " size="20">   
<% if 0 then %> <% end if %> <% fp_sQry="SELECT * FROM Table1 WHERE (""Product description"" LIKE '%::Product description::%')" fp_sDefault="Product description=null" fp_sNoRecords="" fp_sDataConn="Database1" fp_iMaxRecords=0 fp_iCommandType=1 fp_iPageSize=50 fp_fTableFormat=True fp_fMenuFormat=False fp_sMenuChoice="Product Group" fp_sMenuValue="Product Group" fp_iDisplayCols=5 fp_fCustomQuery=False BOTID=0 fp_iRegion=BOTID %>
Product Group Product description Pack size Retail price Picture
No records returned.
<%=FP_FieldVal(fp_rs,"Product Group")%> <%=FP_FieldVal(fp_rs,"Product description")%> <%=FP_FieldVal(fp_rs,"Pack size")%> <%=FP_FieldVal(fp_rs,"Retail price")%> <%="" & FP_FieldVal(fp_rs,"Picture") & ""%>

 

Product Notes - (use the product group from the above table to search i.e. blades) " size="20">      

           List of product groups available <% if 0 then %> <% end if %> <% fp_sQry="SELECT * FROM Product_group WHERE (""Product Group"" IS NOT NULL)" fp_sDefault="" fp_sNoRecords="No records returned." fp_sDataConn="Database1" fp_iMaxRecords=0 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=False fp_fMenuFormat=True fp_sMenuChoice="Product Group" fp_sMenuValue="Product Group" fp_iDisplayCols=1 fp_fCustomQuery=False BOTID=2 fp_iRegion=BOTID %>

<% if 0 then %> <% end if %> <% fp_sQry="SELECT * FROM Product_group_notes WHERE (""Product Group"" LIKE '%::Product Group::%')" fp_sDefault="Product Group=null" fp_sNoRecords="" fp_sDataConn="Database1" fp_iMaxRecords=0 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=True fp_fMenuFormat=False fp_sMenuChoice="Product Group" fp_sMenuValue="Product Group" fp_iDisplayCols=3 fp_fCustomQuery=False BOTID=1 fp_iRegion=BOTID %>
Product Group Heading Notes
No records returned.
<%=FP_FieldVal(fp_rs,"Product Group")%> <%=FP_FieldVal(fp_rs,"Heading")%> <%=FP_FieldVal(fp_rs,"Notes")%>

   

Number of page visits Hit Counter