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.

Answer 1

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.

Answer 2

I've solved my problem.
Thanks.

Answer 3

Not Clear. Can you explain it bit more.