unique composite key

  • Thread starter Thread starter inungh
  • Start date Start date
I

inungh

I would like to create a non-primary key, but unique composite index.

I know that I can create a unique index using index no diplicate
property of table and set primary key to set my compsite key.

I am not sure, does Access support unique composite index?

Like I want ot have myField1 and MyField2 have unique value, but they
are not primary key.


Your help is great appreciated,
 
On Mon, 22 Sep 2008 06:02:20 -0700 (PDT), inungh <[email protected]>
wrote:

Yes. Open the Indexes dialog. You can now create a composite index.

-Tom.
Microsoft Access MVP
 
Yes. Open the Indexes dialog. You can now create a composite index.

-Tom.
Microsoft Access MVP








- Show quoted text -
Click to expand...

I mean unique composite index.
Thanks again,
 
I mean unique composite index.
Thanks again,
Click to expand...

Do what Tom suggested. Check the "Unique" checkbox on the dialog box.

Yes, Access can create a unique composite index, I believe on up to ten
fields.
 
What you do is enter an index name of your choice in only one row of the
first column of the dialogue, and the column names in separate rows of the
second column, leaving the first column blank for all but the first row.
Select the first row (the one with the index name) and then select 'Yes' as
the Unique property.

Ken Sheridan
Stafford, England
 
What you do is enter an index name of your choice in only one row of the
first column of the dialogue, and the column names in separate rows of the
second column, leaving the first column blank for all but the first row.  
Select the first row (the one with the index name) and then select 'Yes' as
the Unique property.

Ken Sheridan
Stafford, England






- Show quoted text -
Click to expand...

Thanks millions,
 
Back
Top