Thanks Mr or Mrs (whichever it may be 🙂 )

The 'aspnet_Membership (dbo)' table in which the "Email" column resides already has a primary key set on another column (UserID). And...

Apologies about the seemingly inane questions, but this is like learning a new language.

I'm trying to create a PK-FK relationship between two columns in two separate tables. The PK is...

Thanks Koen.

Can't answer your questions fully I don't think as I am not really up to speed on DB terminology 🙂

About defining the relationship, I am doing it inside...

Not sure about that 😀

Hello John,

By hook or by crook I actually managed. Still not sure how... but all's well that ends well. It did unearth other self-inflicted issues too unfortunately.

Thanks to you and...

John,

To be brutally honest, I've never done anything like this before. I hadn't expected to be going so far down the road with it, but that's usually the case when...

Ok, here it is. Thanks.

Thanks John.

I must admit to mostly not understanding your suggestions. So I'll start from the easy part... the bottom ...

Where would I enter that query. In SSMS somewhere?

Then... does my...

Thanks very much Simon. I think I actually understand all of that. Useful!

I'm always happy to follow the easy route so I'll try to change the collation of the local...