Relationships - one-to-many?

[RobertLees]

Hi

I've selected a number of tables to the relationship window. When I drag the primary key on one table to the corresponding foreign key on another table, the link created is one-to-one. I want one-to-many. Why did it create one-to-one? How do I change this to one-to-many?

Thanks

 

[Dwight]

My guess is that you have a problem with your design. Are you sure you are linking a primary key to a foreign key? Can you post a sample of what you are doing as a zip file?

 

[neileg]

If you right click on the link in the Relationship window you can edit the link properties.

 

[ScottGem]

Just to add to what Pat and the others said. it may be that you have a unique index on the foreign key. If you do, Access will also interpret that as a 1-1.