Setting up Relationship Tables

[Carla]

Here I am ready to struggle with another Access Assignment. I think
where I run into trouble is with the relationship talbes - the tables
that join other tables with 2 primary keys.

I have in my book set up the Table for a Payroll module:

Hours Worked Table: EmployeeNo, PPEnded, RegularTimeHours,
OverTimeHours

The EmployeeNo and PPEnded fields are double underlined - EmployeeNo
is a primary key in the Employee Table. I don't see PPEnded as a
primary key in any other table, so I'm guessing it is also the primary
in the Hours worked table.

Do I click both fields and the Key symbol for primary in the table
design window?

Thanks

 

[John W. Vinson]

Do I click both fields and the Key symbol for primary in the table
design window?

Ctrl-click so they're both selected, yes.