Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Thread Tools Search this Thread
Old 08-08-2009
Join Date: Aug 2009
Posts: 1
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
Reply With Quote
Old 17-05-2011
Join Date: Apr 2009
Posts: 567
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.
Reply With Quote

  TechArena Community > Software > Windows Software
Tags: , , , ,

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

All times are GMT +5.5. The time now is 08:47 AM.