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 |
|
JJins
Yak Posting Veteran
81 Posts |
 Posted - 2010-11-11 : 12:15:56
|
| I have set up three tables in a new database in SQL2005express how do I relate the tables. Above the object explorer I have selected the gold key to set up primary. But when i click the relationship button, I cant figure it out.Thanks as always!GG |
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-11-11 : 13:14:55
|
| Right click, new relationship. Then, under Tables And Columns... (epxand the option) click the elipsis (...)It should be pretty easy for you from there. You just select the tables/columns that are required for the relationship.===http://www.ElementalSQL.com/ |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Setting up FK and PK