composite key in access

[yasmin0907]

Hi guys
I wanna create composite key in access but the thing is that I want the tuple to be unique not each one of keys
for example one person can not have the same account number at the same time but can have another account number.
can you help me with this please?

[FishVal]

Hi, yasmin.

If I've understood your correctly, then you want to have composite key with one of the fields be unique. Did you try the obvious things like:

• Set composite primary key
• Set "Indexed" property of the field expected to be unique to "Yes(No duplicates)"

Kind regards,
Fish

[ADezii]

Hi guys
I wanna create composite key in access but the thing is that I want the tuple to be unique not each one of keys
for example one person can not have the same account number at the same time but can have another account number.
can you help me with this please?

I'm a little confused on your request also, but to create a Composite, Primary Key where the combination of 2 Fields is Unique, but there can be multiple entries in the individual Fields:

1. In Table Design View.
2. Select the 1st Field of the Composite Key
3. Hold down the Control Key (CTRL) while selecting the 2nd Field of the Composite, Primary Key
4. Right Click the selection
5. Click Primary Key (1st option in the shortcut menu)

'Records 1 through 4 will be accepted, Record 5 will not!

..............Field 1                  Field 2
Record 1      Dog                      Male
Record 2      Dog                      Female
Record 3      Cat                      Female
Record 4      Mouse                    Female
Record 5      Dog                      Male        'that's a NO NO!