Setting FK in SQL server management studio

I am not an experienced programmer and am setting a small sports team DB using SQL Management Studio for our web site.  I have two tables.  One is TeamType.  It has a PK of TeamTypeID, then TeamName.  That will hold team types like baseball, soccer, basketball, etc.  Then I have a Team table.  PK is TeamID. I would like a FK of TeamTypeID.  But without coding, I don't see how to set this as a FK in the Team table.  Thanks for helpl
hconantAsked:
Who is Participating?
 
nybelleCommented:
Within Management Studio, open the keys/indexes properties on the Team table. There you can create the FK.
0
 
hconantAuthor Commented:
I did that, tried that.  I established the relationship but there is no FK next to the field in the database design view.
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
sridharkamalaConnect With a Mentor Commented:
Expand TEAM table -- > Keys and you should see the Foreign key.
0
 
hconantAuthor Commented:
Maybe I am doing that wrong.  When I go to Team table and go to Add in the Indexes/Keys it defaults to adding IX_Team*, which is I assume an index, not a key?  If I go to Foreign Key Relationships it seems to be where I can establish the relationship.  In this case I have a FK_Team_TeamTypeID.  Foreign Key Base Table=Team.  Foreign Key Columns=TeamTypeID. Primary/Unique Key Base=TeamType. Primary/Unique Key Column=TeamTypeID.  This looks correct to me, but there is no FK next to the TeamTypeID column in Team table, like there is a key symbol next to TeamID.  Have I successfully created the relationship and don't know it?
0
 
hconantAuthor Commented:
In VWD, Database Explorer there is no Keys in the Team table ladder.  All i have are the columns.
0
 
hconantAuthor Commented:
I opened the DB with SQL Management Studio and I see the keys.  But that doesn't show in VWD.  Maybe it just that way?
0
All Courses

From novice to tech pro — start learning today.