Author Question: How do you create a one-to-many relationship in Access? What will be an ideal ... (Read 16 times)

Collmarie · **on:** Aug 28, 2018

How do you create a one-to-many relationship in Access?

What will be an ideal response?

Question 2

You generally work with two documents during a mail merge, the main document and the ________ source.

Fill in the blank(s) with correct word

cegalasso · **Reply #1 on:** Aug 28, 2018

Answer to Question 1

A one-to-many relationship between two tables is created by:
a. Making sure that the two tables have a field in common, usually the primary key from the one-side table. That field is made the foreign key in the many-side table.
b. Using the Relationships window, you connect the primary key to the foreign key.
c. Populating the foreign key.

Answer to Question 2

data