I'm having a problem with a 3 field chained dropdown.
The first field gets its values fine. After selecting a first value, the second list is populated, showing the first value in that second field.
But the third field never gets a value until you pick at least the second value in the second field. Then the third is populated...then you can go back and select the first value in field 2 and you will then get selections loaded for field 3 - unacceptable way to get values.
I suspect that after you select a value in field one, the list for field 2 is displayed but not actually a selection. I think it needs to come up blank first forcing the user to make a selection, which in turn gets the list for field three.
(Whew!)
Thoughts? Is there a place I can fix this in the code? Thanks all!!
Look here...I'll leave it up a while.
http://www.mozaicltd.com/protrax/DT/dropdowntest
Go to TransportationPicks...go to Add New record.
First field select Automobiles, list 2 is then populated.
Select Trucks in the second field. No values for field 3 appear.
Now go to field 2 and pick Cars, now field 3 is populated.
Now you can go back to field 2, pick Trucks and you will get values for field 3.
Like I said, I think field two needs to come up blank and force the user to pick a value, then field three will be populated - but should show blank - in case you want a 4 field chain <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1850&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
BTW, I'm using one table for all the lookups - fields are Id, ParentId, ValueName.
