Select both primary key table and foreign key table before selecting any field for the relationship.

You tried to select the columns from one table of a relationship before indicating what the other table is.  You must first indicate both tables before proceeding to choose columns.