I have a mapping table as such:

```
english.Phrases (PhraseId int, WordId int, Order int)
Primary Key Clustered (PhraseId, WordId)

```

And another table:

```
english.RelatedPhrases (RelatedPhraseId int, PhraseId int)

```

How do I setup a foreign key relationship between the 2 tables using `PhraseId`?

Edited to answer comment on which database:
I'm using Microsoft SQL 2008, hence, I changed the tag.

The mapping should be as follows; consider the following phrases:

```
1. "turn out to be", phraseId of 1
2. "grow to be", phraseId of 2
3. "turn into", phraseId of 3
4. "come to be", phraseId of 4

```

Each word has an entry in the following table:

```
english.Words (WordId int, Word varchar(20))

```

The english.Phrases table has the following entries for "turn out to be":

```
(1, @word1Id, 1) @word1Id = id of 'turn'
(1, @word2Id, 2) @word2Id = id of 'out'
(1, @word3Id, 3) @word3Id = id of 'to'
(1, @word4Id, 4) @word4Id = id of 'be'

```

Now, what I want from the english.RelatedPhrases table is to have the PhraseId of 1, which represents "turn out to be", to relate to the other phrases, say in this case, 2, 3, and 4; all 4 entries in RelatedPhrases having RelatedPhraseId = 1.