Yes. In a perfect world, if you're dealing with customers who have lots of phone numbers or multiple email addresses, you should put them into a separate table. Anyone familiar with Google Contacts knows how this works. However, I don't get into multiple tables and relationships until Expert Level 1, so for right now, you can make multiple fields in the same CustomerT table: HomePhone, CellPhone, WorkPhone, etc. And that's generally fine if you've only got 2 or 3 numbers. However, a properly built database where customers may have 1 or 20 different numbers (or email addresses) should use a second, related table. Don't worry. We'll get there soon...
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.