Select both primary key table and foreign key table before selecting any field for the relationship. (Visual Database Tools)
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.