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 together make them a dual Primary Key combination.…In other words, I can combine two fields that individually may contain…duplicates but the unique combination of the two can only happen once in the table.…For example, if I'm offering a series of Access Classes I need one table to…store the information about the classes and a second table to store the…information about the students.…

My third table contains the attendance tracking for their participation, and…that's where the multi-field Primary Key comes, any student can only take…one class one time.…Right-click on the tabs and choose Close All.…Now, let's open up Attendance in the Design View.…I am going to set up my first two fields, Student and Class, with Lookups so…that they pull the IDs from the other two tables.…I'll start with student, I'll click on the Data Type where it says Number and…