RE: [PHP-DB] My question in precise reg PHP and relational tables.

hi, I have added my question , my main Aim at the end of this explanation. 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 uses a text filed to show the values of the category.

If there are two or more categories for example Beef and Diary then    "Beef | Diary" is shown in the text field.

Now I want to change that text field into a drop down list and enable multiple selection of the values. And if I want to update the category field in program clips I will select one or more values in the drop down list and do some programming to put a pipe symbol in between the selected values ( in order to make MySQL to understand and interpret). :::::::::::::::::::::::::::::::::::::::::::::::::::::: My Question in Precise is 1. is there aby way in realation databases that the values that appear in the FORM are the values from the 'categories' table. If I add more categories then those values can be automatically added into the FORM from whcih I update the 'category' field in 'programClips' table. _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus