Hi, I am a relative newbie with PHP and have two questions that I'm hoping someone can help me understand how to do: 1. I have made a webform that has five input fields for entering data into a mysql table. One of the fields on my form I would like the user to select from a defined list of options. However, I would like this list to be extracted from my database, and not one that I have to hardcode the options. 2. For this same field, the list that the user would select from is a name. However, there is another table in my database that assigns this name and ID number and it is in fact this ID number that needs to go into the particular table that my form is set up to enter into. Is there a statement that I can write that will let the person select the name, but then what is entered into the form is actually the ID number? I can provide more detail if needed, but any insight would be most helpful! Taneya