Better MySQL table structure?

[jodbowrs]

Server version: 5.1.53-community-log

 

Maybe the question I should be asking then is how should I set up one or more table(s) to contain our members contact info plus the multiple fields of work that they work in?

[requinix]

Simply, a table for the members including contact information, a table for fields of work, and an associative table between the two.

 

If you don't know what types of contact information you'll be recording then there's two more tables: one for type of information ("Phone", "Email", etc.) and another associating contact with type of information ("Phone") with the actual information ("555-1212").