Results 1 to 2 of 2

Thread: access - one to many relation

  1. #1
    Join Date
    Aug 2009

    access - one to many relation

    I have a question regarding access and one-to-many relations:

    I want to built up a relationship between two tables. One table contains different information and personal contact detail of (in this case) consultants and the other one about trainees. The main idea is that each consultant can be the attachment figure for many trainees.
    I have introduced as foreign key in my consultant table and as primary key in the trainee table the "trainee_id". If I try to build a relationship between these two fields, access sees automatically my primary key as the one side and my foreign key as the manyside. Unfortunately, that is not what I wanted: it would namely mean that each trainee has many consultant as attachment figure.
    Anybody knows, how i can change my tables in order to build the relationship which gives me the information I really need (each consultant can be the attachment figure for many trainees)? I tried to change also my primary key in the trainee table, but if I make a relationship between the two "trainee_id" (none is a primary key), I cannot enforce the referential integrity and obviously at the same time I cannot see on the line nether the "1" nor the "infinity".
    Thank you

  2. #2
    Join Date
    Apr 2009

    Re: access - one to many relation

    A one-to-many is the mainly common type of relationship. During this relationship, one row within Table A can have a lot of similar records within Table B; however a row within table B can have simply one matching row within table A. For illustration, tables of publishers and titles contain a one-to-many relationship: every publisher constructs a lot of titles; however every title comes from a distinct publisher. A one too many relationships are produced if only one of the associated columns is a primary key or has a matchless constraint. Within Access, the side of the primary key of a one-to number is indicated by a key symbol. The foreign key side of an association is represented through an infinity symbol.

Similar Threads

  1. Replies: 22
    Last Post: 03-05-2012, 03:06 PM
  2. Replies: 4
    Last Post: 16-10-2011, 12:13 AM
  3. Explorer vs. Firefox in relation to windows sizing
    By Dhatri in forum Technology & Internet
    Replies: 6
    Last Post: 16-09-2011, 07:16 PM
  4. Replies: 3
    Last Post: 19-12-2010, 07:57 AM
  5. What is the relation between view and Sequence
    By rohit007 in forum Software Development
    Replies: 4
    Last Post: 13-02-2009, 11:51 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