Search code examples
sql-server-2008ssms

Cannot Specify Foreign Key Tables When Adding New Foreign Keys

I'm trying to use the Relationships dialog in SQL 2008 to add a new foreign key to a table field. When I go to add one, I am not able to change and specify the Foreign Key Base table or any others in the "Tables and Columns Specification" area...they're all greyed out for those values and uneditable and I"m not sure why.

Solution

  • Have you clicked the ellipsis button to get the wee dialog box?

    The section "Tables and Columns Specification" area has a wee button where you choose the tables and columns: you can't enter stuff directly.