Create relationship in SQL7.0

[dimitric]

Greetings,

I just migrated my tiny access DB to SQL7.0 successfully. The problem I'm having is that all the primary keys/foreign keys and their subsequent relationships wern't carried over. I've created a diagram and assigned the primary keys (included on the concenated ones) but I can't seem to 'drag the column' to create a relationship.

I'm sure I'm DBO on the db with the necessary permissions. Any ideas?

 

[jitter]

Have you tried right clicking on one of the tables in question and seeing if you can create a new relationship using the relationships properties window? I don't know if that exactly solves your problem but it may help to find out further what is going on.