Luis Cazares (9/21/2012)
Chad Crawford (9/21/2012)
For our app we are going to go with a generic "Phone 1", "Phone 2", etc. up to a "Phone 7" and store each in it's own column in the table. That way we don't have to worry about types and everyone can choose for themselves what "Phone 1" means without having to define static types. Ok, just kidding we're really not doing that, I couldn't resist. :-D:-P:-DThanks!
Chad
Why wouldn't you normalize the table?
We did. I had a twitch of humor while reading Steve's comment and tried to think of the worst design possible. I did add that we are not really doing that, sorry that it didn't carry through in the post.