Yes. The tables need to be related. Since FileMaker is relational, it works with the relationships. Without a relationship, FileMaker can't see the other table and wouldn't know which record from the unrelated table to pull from.
ExecuteSQL is a function that allows you to reach into any table and grab some contents without a relationship. You could explore that idea. Its a bit more trouble but it will work.