On Fri, 4 Jun 2010 06:52:54 -0400, "Douglas J. Steele"
<NOSPAM_djsteele (AT) NOSPAM_gmail (DOT) com> wrote:

Additionally you need a unique index (typically the Primary Key) over
the field(s) on the 1-side. On the fields on the many-side there is no
unique index or PK (otherwise you would get a 1:1).

Then you need to go in the Relationships form and draw the relation
from the field(s) on the 1-side to those on the M-side. It's also
highly recommended to enforce the relationship (see checkbox in
Relationship form).

-Tom.
Microsoft Access MVP