I am a newbie and because I have so much database development/design, I am having trouble with some functions I need. I have two questions:
1. How would I go about populating a Select List dynamically? The select list will be a table from available options that can change. Therefore I would like to query the database table for all the available options and use them for the select list.
2. Because of my database development experience, I keep trying to design the database. When designing my site, is it a good idea to think about my database tables design and create my pages from a good relational database design? For example: A Member can have a different Membership type each year. In good database design you would have a relationship between at least two tables so that your Membership table would not have the member record recorded each year resulting in duplicate membership person record for the same person for each year.