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

[Collmarie]

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]

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

[Collmarie]

Thanks for the timely response, appreciate it

[phuda]

Wow, this really help