I am building a data base of equipment across several manufacturing
facilities. There are several pieces of equipment in each facility. I have a
table that contains facility name and equipment ID among other fields. More
than one facility may use the same ID for a piece of equipment but the
combination of facility and ID are unique. I am trying to assign a multiple
field primary key to this table but when I try to save I get a pretty
generic error message that lists a number of probable causes. The only cause
that seems to fit is that the index need to be set to accept duplicate
entries. When I try to set unique to no in the index properties I get
another error message that says I can't set the unique property  to on a
primary key. I am confused and bewildered by this. Can any one help me on
this apparently simple task?

TIA

Steve H