Problem with dynamic list boxes

[nemati_mojgan]

Hi everybody,

I have a big problem with dynamic list boxes which retrieve data from two tables. I've read some solutions before in another thread, but I couldn't solve my problem.

I have a table in MYSQL database which includes the engineering fields, e.g. Civil engineering, Chemical Eng, and etc. In second table I have the subcategories for each engineering category which mentioned above. I have 2 list boxes; one retrieves data from engineering category table, second one retrieves data from the subcategory engineering table depend on what has been selected from the first lisbox. For example, if I want Civil Engineering from first lisbox, the second listbox will be loaded by related subcategories for Civil Eng from second table. After all I want to insert these data to another table after submitting by user.

I would be grateful to have your help.

Thanks in advance

[ccgorman]

What is the question?

Why not use one table with an id, ref and name. i.e.

1,0,Civil engineering
2,0,Chemical Eng
3,1,Civil engineering sub cat 1
4,1,Civil engineering sub cat 2
5,1,Civil engineering sub cat 3

[nemati_mojgan]

Originally posted by ccgorman
What is the question?

Why not use one table with an id, ref and name. i.e.

1,0,Civil engineering
2,0,Chemical Eng
3,1,Civil engineering sub cat 1
4,1,Civil engineering sub cat 2
5,1,Civil engineering sub cat 3

Thanks for your attention.

The question is: how can I use these two related listboxes and insert the selected data to another table?

The reason that I use 2 tables is that I have already a table which is engineering fields and related to another tables, I just want to creat a table for subcategories.

Hope I could explain the problem clearly.

Thanks again