I'm not sure how you would. PK/FK is basically enforcement of matching values and field types (and sizes) in 2 different tables. That said, I posted the only way I can think of getting even close to what you want. If you have a "prefix" (I use the term loosely) that matches, then you could join on that. If you index the column, you shouldn't have terrible performance.

What happened when you tried it?