In Microsoft Access, a relationship between two tables is created:

by entering the name of the foreign key in the appropriate table in Design View

by entering the name of the primary key in the appropriate table in Design View

by dragging the primary key column of one table onto the foreign key column of the other table in the Relationships window

by dragging the primary key column of one table onto the primary key column of the other table in the Relationships window