I am getting ready to start building an application and I am kind of stuck on how to store information in the database. I currently have one table with all of the user info: username, password, name, address, email, etc. When a person registers they fill in all the information above and then they need to answer a few questions, for example the types of income that they receive. Under this category I would have: Wages, Food stamps, Disability, Alimony, and Other. I would like these categories to be stored in my database as a separate table, so that they show up for everyone. And when someone returns to the site only show information pertaining to the categories the registrant answered. But when someone chooses Other they get the option to enter in a value. Now what I would like to do is if someone enters Other, have that added to the database and make it a new option for the registrants following that person. So say someone puts in Social Security for Other, the people after that registrant should have the following choices: Wages, Food stamps, Disability, Alimony, Social Security, and Other.

Does anyone have any suggestions for this?

Your help is greatly appreciated.