newbie can't edit relationship type...

[cassidy]

I want to create a one-to-many relationship. I drag the primary key
field from table A to the matching foreign key field in table B. The
edit relationships window appears and says this is a one-to-ONE
relationship, with no way that I can see to change the type. What am
I missing?

Using Access 2003 on an iMac running Parallels so that I can run this
Windows program. SEEMS to work fine, but could this possibly be
related? Or am I just COMPLETELY missing something here?

Thanks much for any help.

 

[Dirk Goldgar]

I want to create a one-to-many relationship. I drag the primary key
field from table A to the matching foreign key field in table B. The
edit relationships window appears and says this is a one-to-ONE
relationship, with no way that I can see to change the type. What am
I missing?

Using Access 2003 on an iMac running Parallels so that I can run this
Windows program. SEEMS to work fine, but could this possibly be
related? Or am I just COMPLETELY missing something here?

Thanks much for any help.

What you describe usually happens when the foreign key field has been set to
have a unique index. Make sure that field's Index property is set to either
No (in which case creating the relationship will also create a hidden index)
or "Yes (Duplicates OK)".