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".
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.
|Tags: microsoft, microsoft access, microsoft office, primary key, table|
|Thread Tools||Search this Thread|
|Similar Threads for: "access - one to many relation"|
|Thread||Thread Starter||Forum||Replies||Last Post|
|Windows cannot access the specified device path or file. You may not have the appropriate permission to access the item||green777||Operating Systems||22||03-05-2012 02:06 PM|
|Aveline's Dragon Age II: Mark of the Assassin quest in relation to DA lore SPOILERS||Kamalaa||Video Games||4||15-10-2011 11:13 PM|
|Explorer vs. Firefox in relation to windows sizing||Dhatri||Technology & Internet||6||16-09-2011 06:16 PM|
|windows cannot access the specified device path or file. you may not have appropriate permissions to access the item||gilsoffer1||Operating Systems||3||19-12-2010 07:57 AM|
|What is the relation between view and Sequence||rohit007||Software Development||4||13-02-2009 11:51 PM|