unique composite key

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,
 
T

Tom van Stiphout

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
 
I

inungh

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,
 
J

John W. Vinson

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.
 
K

Ken Sheridan

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
 
I

inungh

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Composite Primary Key with an ID and Index 2
Same invoice number- different country 3
No Duplicates for Full Name 7
How do you create a composite key that can be referenced? 3
Correct design and primary keys for linking multiple tables 5
composite key unmatched query 1
is this a good instance for using a composite key? 0
Problem with composite key 4

Top