Creating a multi-field primary key


show more Creating a multi-field primary key provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Creating a multi-field primary key

There may be times when you don't have a field that makes a good primary key and you don't want to create a meaningless ID field. A third option is to combine two fields and make them a dual primary key combination. In other words, I can combine two fields that individually may contain duplicates, but the unique combination can only happen once. For example, if I'm offering a series of Access Classes, I need one table to store information about the Classes and the second table to store information about the Students.

The third table Attendance contains the tracking for their participation and that's where the multi-field primary key comes in, right-click on Classes to close it and right-click on Students to close it. In the Attendance table, we're going to set the first two fields with lookups, so they pull IDs from the other two tables, I go into Design View and under Student, I'll change the data type to Lookup Wizard. We want to Lookup field to get the values ...

Creating a multi-field primary key
Video duration: 4m 17s 3h 43m Intermediate

Viewers:

Creating a multi-field primary key provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...