Lemme guess... I can't do this? It's not showing up in the designer as a relation.

of course you can do that. You defined an FK on an nvarchar? Or you want to create a custom relation ?