If two tables do not already have relationships, how can they be related in the Design view?

In Design view, create a relationship by dragging the matching field from one table onto the corresponding field in the other table. Usually, one field is a primary key and the matching field is a foreign key. This links the tables; simply setting primary keys does not establish the relationship by itself.

AI-written and checked against the verified answer.