Re: setting a multi-field key index

Tech-Archive recommends: Speed Up your PC by fixing your registry

I don't believe it changed from the previous way to do this...

Open the table in design view. Highlight multiple fields. Click the
primary key.

If you are looking to set a multi-field index that is NOT a primary key,
open the index window and add multiple fields to a single (named) index.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

"dennist685" <dennist685@xxxxxxxxxxxxxxxx> wrote in message
news:5AEC0CBA-3448-498D-B4E4-CD6F9DF81A03@xxxxxxxxxxxxxxxx
in Access 2007. I've scoured Microsoft's kb without an answer. Can
somebody
help/

Dennist

.

Relevant Pages

  • Re: Phone call log, multiple fields for different times
    ... TimeRangeID (an Autonumber field, the Primary Key) ... Microsoft IT Academy Program Mentor ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Table relationships
    ... type auto-number in the Project form, and long integer number in the Updates ... "Jeff Boyce" wrote: ... Microsoft IT Academy Program Mentor ... You set a primary key in design mode. ...
    (microsoft.public.access.formscoding)
  • Re: Table relationships
    ... type auto-number in the Project form, and long integer number in the Updates ... "Jeff Boyce" wrote: ... Microsoft IT Academy Program Mentor ... You set a primary key in design mode. ...
    (microsoft.public.access.formscoding)
  • Re: Table relationships
    ... Microsoft IT Academy Program Mentor ... "Jeff Boyce" wrote: ... You set a primary key in design mode. ... my Project_ID field in the Project form is an auto-number field; ...
    (microsoft.public.access.formscoding)
  • RE: Primary Key
    ... CREATE TABLE Table2 (Id COUNTER CONSTRAINT PrimaryKey PRIMARY KEY, ... Create and Drop Tables and Relationships Using SQL DDL ... Microsoft Access Support ... Microsoft Security Bulletin MS03-026? ...
    (microsoft.public.access.macros)