Thank you for your post.
What field(s) is in the relationship between "people" and "people contact"? Make sure the fields are the same type (text, number) or the relationship can fail. Can you also provide a real-life example? That may help with determining possible causes.