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.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 1.