microsoft access 2002 training - 1

microsoft access 2002 training - 1 - 1 relationship

Resolved · Low Priority · Version Standard

1 - 1 relationship

Paul has attended:
Access Intermediate course
Access Advanced course

by - delegate Paul gold contributer [121 posts] (2007 Oct 9 Tue, 09:37) Reply

How can I create a one to one relationship?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
Full Schedule: See all 52 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: 1 - 1 relationship

by - trainer Carlos gold contributer [479 posts] (2007 Oct 9 Tue, 09:49) Reply

Paul

A One-To-One relationship can only be created between two tables that have the same Primary key.

eg.

A Table containing Employee Details like Name, Address, Home Phone No., with the EmpID as a Primary Key.

A second table containing Salary Details like Basic Salary, Bonus, Pension, with the EmpID also as a Primary Key.

When connecting these two tables through the EmpID it creates a One-To-One relationship.

Hope this helps.

Carlos