I can't figure it out, so please help:
Database tables:
table1 has two columns named id, location and location column will be display in dropdownlist1.
table2 has many columns including a Resource column that i want to display in dropdownlist2 when the user select a name from dropdownlist1, content of dropdownlist2 should dipslay the right ...