Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Relatings tables

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Relatings tables

Resolved · Low Priority · Version 2007

Reply Thu 17 Mar 2011, 16:26Delegate Chris said...

Chris has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Relatings tables

I am not clear how access determines which is the 1 and which is the "many" tables.

Also how does having multiple relationships between tables affect the result.

For upcoming training course dates see: Pricing & availability

Reply Mon 21 Mar 2011, 09:14Trainer Simon said...

RE: Relatings tables

Hi Chris,

Thank you for your question and welcome to the forum.

Access assigns the one part of a relationship to the table with the Primary key and the Many to the Foreign key in the related table.

e.g. Customer table and Orders table:

Primary Key - CustomerID in the Customers table
Foreign Key - CustomerID in the Orders table

Do you mean a junction table where you have multiple foreign keys linking to Primary keys in other tables?

Regards

Simon

Reply Wed 20 Apr 2011, 14:23Trainer Simon said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Wed 27 Apr 2011: Automatically marked as resolved.

Access articles

· MS Access can promote teamwork
· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps
· So what's new in Access 2007?
· How To Use The Analyze Table Tool In Access
· Learn The Secrets About Splitting An Access Database

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

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.

View all Access hints and tips