Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
weitzhandler
Yak Posting Veteran
64 Posts |
 Posted - 2009-01-24 : 12:32:28
|
| I have a contact table and I am not sure how to make the phone column, many contacts might have many phones and many phone types.please share me with your experience.thanks.Shimmy |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-24 : 13:32:35
|
| might be better to add another table with phonetype and number.the table will be having fk relationship to contact table based on contactid. each record in that table corresponds to a phone detail of a contact with particular type |
 |
|
|
|
|
|
Need help designing a table