Relationships between tables must be based on common fields.

Question

Quizplus · Accepted Answer

This is true because relationships between tables are established by connecting a field in one table to a corresponding field in another table. This allows the tables to be joined together in queries, forms, and reports, enabling users to view and analyze related data from multiple tables at once. Without a common field to link them, two tables cannot be related to each other.

Relationships Between Tables Must Be Based on Common Fields