[Costin Trifan]

Originally Posted by RyOn

ok i have 2 tables in my database, table 1 and table 2.

In table 1 i have a column that in each row has a different word

Now in table 2 i want to be able to have a column where by when i go to enter data i am given the option of selecting words from a drop down menu, this list is is retrieving its data from the column data from table 1.

remember my question is about how to do this in mysql query browser.

i have done this in ms access but do not know how in mysql query browser.

Maybe I didn't understand you correctly, but you want to display the content of one table into another table's column as a dropdown list in your mysql client, like PhpMyAdmin or SQLYog and not in a php page, right? (please clarify)

because my answer was related to the first part and not the second like kieransimkin pointed out.