Populating a multiple dropdowns

My previous question is below. I was told to purchase Dynamic Dropdown to accomplish this task. Followed the instructions but when I select a customer from the Parent Dropdown, the Child dropdown isn't getting populated.



Is there a way in data assist when I select a customer from a dropdown list (Customer) that another dropdown(Contact) would be populated with contact information associated with that customer id?

Please see attachment.

Any assistance given will be appreciated.

Thanks

there is no page attached to this.

please compress the php page to a zip archive and attach the zip file to your reply.

it would also be helpful to have a link where we can see this in the browser.

Please see attachment.

You can also view the page at contracts_Insert.php under Customer Information.

When you select a customer, only contact information for that particular customer must showup in the Contact dropdown.

1) The recordset that is being used for the Dynamic Array, WADAsrcontact, is not returning any records, it relies on the customerid querysting variable to return records.

the dynamic array recordset needs to be able to return the customers and contact info.


2) you have added The Populate List from Array behavior to the onchange event of the contact list, it needs to be set to the onchange event of the customer list.

Doesn't work, getting a blank screen.

Please see attachment.

when i test your link, the page is loading but not showing the main content area, this is because you have set the height for the cointent area to 1%.

in the admin.css file, change:

#outerWrapper #contentWrapper {
  height: 1%;
  min-height: 0;
  padding-bottom: 10px;
  padding-left: 0px;
	padding-right:0px;
  padding-top: 10px;
	overflow: hidden;
}

to:

#outerWrapper #contentWrapper {
  /*height: 1%;*/
  min-height: 0;
  padding-bottom: 10px;
  padding-left: 0px;
	padding-right:0px;
  padding-top: 10px;
	overflow: hidden;
}

you will also need to move the Create Dynamic array code from line 93 - 139:

<?php

if ($row_WADAcontact)     {

  echo "<SC" . "RIPT>\n";

  echo "var WAJA = new Array();\n";



  $oldmainid = 0;

  $newmainid = $row_WADAcontact["customerid"];

  if ($oldmainid == $newmainid)    {

    $oldmainid = "";

  }

  $n = 0;

  while ($row_WADAcontact)     {

    if ($oldmainid != $newmainid)     {

      echo "WAJA[".$n."] = new Array();\n";

      echo "WAJA[".$n."][0] = '".WA_DD_Replace($newmainid)."';\n";

      $m = 1;

    }



    echo "WAJA[".$n."][".$m."] = new Array();\n";

    echo "WAJA[".$n."][".$m."][0] = "."'".WA_DD_Replace($row_WADAcontact["contactid"])."'".";\n";

    echo "WAJA[".$n."][".$m."][1] = "."'".WA_DD_Replace($row_WADAcontact["contfname"])."'".";\n";



    $m++;

    if ($oldmainid == 0)      {

      $oldmainid = $newmainid;

    }

    $oldmainid = $newmainid;

    $row_WADAcontact = mysql_fetch_assoc($WADAcontact);

    if ($row_WADAcontact)     {

      $newmainid = $row_WADAcontact["customerid"];

    }

    if ($oldmainid != $newmainid)     {

      $n++;

    }

  }



  echo "var WADAcontact_WAJA = WAJA;\n";

  echo "WAJA = null;\n";

  echo "</SC" . "RIPT>\n";

}

function WA_DD_Replace($startStr)  {

  $startStr = str_replace("'", "|WA|", $startStr);

  $startStr = str_replace("\\", "\\\\", $startStr);

  $startStr = preg_replace("/[\r\n]{1,}/", " ", $startStr);

  return $startStr;

}

?>

to be just after the head instance editable tag:
<!-- InstanceBeginEditable name="head" -->