3 dependent drop down menu's + sql query
Posted on 2000-03-29
This question has 2 sections:
first, I want to have 3 dependent drop down menus - i have an access db with three tables which are relational. The first table (table1) has an id and type name. the second table (table2) has an id, type1_id (which references the id of type1 table), and type2_name. The 3rd table (table3) has an id, class_type_id (which references id of type2 table, and type3_name.
so when i pick a type from table1, i want it to retrieve all the values from table2 that match the id of table1. Then, i want the second menu to select all the values from table3 that match the id of table2.
how can i do this?
the second part is that when the value from the 3rd drop-down has been selected, i want to view the data from the table that is related to this value. so i need to write a dynamic sql query that will take the id of the value selectd from table 3.
i hope this explains clearly what i want, but let me know if more info is needed about the db.