relationship
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Relationship

Relationship

resolvedResolved · Low Priority · Version 2003

replyReply Tue 25 Nov 2008, 13:56Delegate Ayo said...

Ayo has attended:
Access Intermediate course

Relationship

Is there an order on how to create a link between primary key and secondary key

For upcoming training course dates see: Pricing & availability

replyReply Tue 25 Nov 2008, 17:19Trainer Simon said...

RE: relationship

Hi Ayo,

Thank you for your question.

When you are trying to create a relationship, it doesn't matter whether you drag the Foreign key onto the Primary or the Primary key to the Foreign key.

Access will always assign the one part of the One to Many relationship to the Primary key.

I hope this answers your question.

Regards

Simon

 

Please browse our web site to find out more about
microsoft access training and other Microsoft training courses.

Access tip:

Add date to a field

Press CTRL+SEMICOLON

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard