Help on MySql Relational Tables

hi all, I have two tables. 1.ProgramClips ( id, progSummary, category, videoFile)PRIMkey = id. and each id may have 2 or three categories. 2.Category( number,category). categories are : Beef , diary, horticulture etc; I am using PhpMyAdmin as the interface for the mySql Database. The PhpMyAdmin creates a text filed to show the values of the category. Where as I want to replace the text field to put a drop dwon list which can select multiple categories. There is no relation between the two tables. Can any one help me how to do that. _________________________________________________________________ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail