Very simple task - create many-to-one realtion

[ganjan]

Hi. I need some help. It's a very simple task, but somehow I have a hard time making it work. I only need to implement a many-to-one relation in my database.



So far i have Contacts and equipment. One Contact can only own one item and i need to have a many-to-one relation where many contacts can share one equipment...

[RuralGuy]

Normally you would implement a 1:M relationship by putting the PrimaryKey of the 1 side into a ForeignKey field of the Many side. Both fields need to be the same data type and it makes it easier to understand if you name the fields the same.

[ganjan]

I just need to know how i set up a very simple database with a many-to-one relation. Thats it. If you just set up a very simple example to help me understand? I have tried, but access only shows one-to-many relations.

EDIT: Forget my last post..

[RuralGuy]

Why do you have the intermediate table Relasjoner?