Results 1 to 4 of 4
  1. #1
    ganjan is offline Novice
    Windows Vista Access 2007
    Join Date
    Jun 2009
    Posts
    2

    Very simple task - create many-to-one realtion

    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...


  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    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.

  3. #3
    ganjan is offline Novice
    Windows Vista Access 2007
    Join Date
    Jun 2009
    Posts
    2
    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..

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Why do you have the intermediate table Relasjoner?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access Simple Stuff, help
    By clwclw in forum Access
    Replies: 1
    Last Post: 05-02-2009, 03:10 PM
  2. Very simple question!
    By fiddley in forum Programming
    Replies: 2
    Last Post: 04-28-2009, 02:16 AM
  3. Help with a simple query
    By JohnnyO in forum Queries
    Replies: 1
    Last Post: 02-11-2009, 09:43 PM
  4. Please help w/ simple languages db
    By TalentNation.net in forum Database Design
    Replies: 0
    Last Post: 01-23-2009, 09:11 AM
  5. Export Access reports/query results to Outlook Calendar/Task
    By kfinpgh in forum Import/Export Data
    Replies: 0
    Last Post: 02-22-2007, 01:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums