Getting Dynamic Dropdowns to work...

I've followed the tutorials to set up the a parent and child dropdown on my insert page... but the child drop down is not doing anything. Just stays empty. The original form was created by DataAssist... not sure if that might be causing an issue? I've attached a copy of the script... Anyone have any ideas what I've done wrong? Thanks in advance!

Looking at the page, you have the Main Cat select list and the Sub Cat select list.

You have applied the Populate List From Array behavior to the onChange event of the Sub Cat select list.

The Populate list from array behavior needs to be applied to the onChange event of the parent select list. It appears the Main Cat Select list should be the parent.

You should apply the Populate list from array behavior to the Main Cat select list instead of the sub cat select list.

I tried that the first time...

I've done it again, but it's still not doing anything... This is the page...

items_Insert.php

and I've attached the latest version...

In fire bug i see the following javascript error:
Error: syntax error
Source File: items_Insert.php
Line: 8, Column: 8
Source Code:
WAJA[0][] = new Array();


It looks like you have a record in the itemcategory table with a blank value in the MainCat_ID column that is causing the problem.

either filter the recordset to not include records with a blank value in the MainCat_ID column or remove those records from the database.

I've just checked and all records in the 'itemcategory' table, do have 'MainCat_ID's... I've attached a screen shot...

your screen shot only shows 20 rows, there are at least 27 being added to the dynamic array. You screen shot does not show a record for "Flower Vases" But it is a part of the dynamic array:


WAJA[0][7][0] = '27';
WAJA[0][7][1] = 'Flower Vases';

Apologies! I was using a trial version of DBManager, and it only displayed 20 records at a time. Please see my updated screen shot... 28 records, all with maincat_id's and the page is still not working! Any other thoughts? Thanks in advance...
Regards,

Dan

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
login.php