1 Reply Latest reply on Nov 16, 2009 8:23 AM by Dan Bracuk

    dymanic form input from choosen selection

    whatsaname

      I've got to fields on called supplier and the second one called product.

      Both fileds can be populated form the database.

      However. If the first field is selected ( Supplier) how

      can i have the secon field ( product) automatically populated with only

      those products applicable form the choosen supplier.

      And the other way around.

      The script i'm having is below.

       

      <cfquery name="rs_supplier" datasource="Reach">
      SELECT distinct "Supplier"
               FROM ProdSupplier
         ORDER BY Supplier ASC
      </cfquery>
      <cfquery name="rs_ProdFam" datasource="Reach">
      SELECT distinct "ProdFam"
               FROM ProdSupplier
      ORDER BY ProdFam ASC
      </cfquery>

      <html>
      <head>


      -->
      </style></head>

      <body>
      <form name="form1" method="post" action="report1.cfm?">
        <p> </p>
        <table width="89%"  border="0">
          <tr>
            <td height="29"> </td>
            <td><span class="style1">REACH Documents </span></td>
            <td> </td>
          </tr>
          <tr>
            <td height="29"> </td>
            <td> </td>
            <td> </td>
          </tr>
          <tr>
            <td height="29">Supplier</td>
            <td><select name="Supplier" size="1" >
              <cfoutput query="rs_supplier">
                <option value="#rs_supplier.Supplier#"> #rs_supplier.Supplier#</option>
              </cfoutput>
            </select></td>
            <td> </td>
          </tr>
          <tr>
            <td height="29">Product Family </td>
            <td><select name="ProdFam" size="1" id="ProdFam" >
              <cfoutput query="rs_ProdFam">
                  <option value="#rs_ProdFam.ProdFam#"> #rs_ProdFam.ProdFam#</option>
              </cfoutput>
            </select></td>
            <td> </td>
          </tr>
          <tr>
            <td height="29"> </td>
            <td> </td>
            <td> </td>
          </tr>
          <tr>