Question

How do you create a relationship between two tables in a database?​

Answer 1

By using a primary key, composite key, or Foreign key. Three types of relationships can be made between tables. One to one, one to many and many to many

Answer 2

Answer:

Create a table relationship by using the Relationships window

• On the Database Tools tab, in the Relationships group, click Relationships.
• On the Design tab, in the Relationships group, click Add Tables (or Show Table in Access 2013).
• Select one or more tables or queries and then click Add.