2 comboboxes - 1 for tables in a DB the other - datafields in a table

Question

Dear All I have a database with 5 tables with one column. I want to use 2 comboboxes - first to have the names of the tables and second to have the fields (without primary key) of the tables so when I choose one field from the second combobox I can see the data written in it. Please help me to do this. Regards Trifon.

Trifon Dinev · Answer

I have one database in MySQL with 9 tables most of them with the same fields but for different objects. for example: radar cvor glide_path etc. with fields: id datetime status door_open smoke high_temp generator where is written 0 for normal 1 for warning and 2 for alarm. in one dropdownlist I have the names of tables: radar cvor glide_path in the other dropdownlist I want to see datetime status door_open smoke high_temp generator. I will have 2 radiobuttons for 1 - warning and 2 - alarm so depending of what I have choosen in these dropdownlists and radiobuttons I can present the data in a table for some time from .... to .... That's it. Thanks in advance. Trifon.

Trifon Dinev · Answer

I've solved my problem. Thanks.

Niradhip Chakraborty · Answer

Not Clear. Can you explain it bit more.

2 comboboxes - 1 for tables in a DB, the other - datafields in a table