Problem creating one to many and not one to one relationship

[WilliamParrish]

Hey guys!

I'm sort of new to Access and I have a problem. I have a database assignment where I need to link some tables. One is a table with a composite primary key and the other is a table with a regular primary key. The composite key is already linked in a one-to-many relationship with the first of its two fields; the problem is the second field also needs to be in its own one-to-many relationship with a different table. Access keeps creating a one-to-one relationship. I need it to be a one-to-many relationship. Any clues why this might be happening?

[June7]

Are these composite key values used as a foreign key anywhere? If not, doesn't have to be a key, can just be a composite index. See if that makes a difference.

If you want to provide db for analysis, follow instructions at bottom of my post.