I have encountered this issue today when adding a new field of type Lookup on an entity Quote, so it means that it's a self-referencing relationship, but the error I'm getting looks like this:
There are no primary or candidate keys in the referenced table 'QuoteBase' that match the referencing column list in the foreign key 'prefix_quote_quote_relatedquoteid'.
Then I tried to manually add the relationship, but it changed nothing. I searched the web for answers but so far I can't even find a clue.
Have you experienced such issue before ? What was the remedy ?