Relationship disabled..?

[kenjoswe]

Hi all,

I've tried to create foreign keys on some tables. But when I choose properties in table design, all entryfields are disabled.

How can I get the entryfields enabled?

/Kent J.

 

[RickCole]

Is this what your are doing:

From Enterprise manager - right click tablename - go to Design Table - click the Table and Index Properties option -click the Relationships tab.

From here can you not enter the details of your foreign keys you require?

Rick.

 

[kenjoswe]

Yes, that is correct!

/Kent J.

 

[RickCole]

It’s a bit of a quirk where someone at Microsoft forgot to add a NEW function from within Enterprise manager.

You can:

Add a database diagram to your database and add all your required tables. From here drag and drop the columns onto the tables where you want to create you foreign keys.

Or

Alternatively you can use the alter table statement to add the foreign keys you require.

Once they are there they can be edited from within Enterprise manager.

Rick.

 

[kenjoswe]

Well I can add tables to the diagram but I cannot save the diagram. I get an Errormessage that says that I should '...Alter Table...'. So I guess I have to do this in code.


/Kent J.