vipulaye
asked on
Unique Constrains using composite key
Hello!
I would like to know if anybody can help me with this.
I am trying to implement an unique constrains using composite key(two columns)
in Access 2000.
For Eg. I have a table called UserItem with Columns UserId and ItemId.
And the Relation between these two entities is many-to-many.
So in the table UserItem the combination of UserId and ItemId should be unique.
I do not know how to implement this composite key unique constrains in the Access table.
Any help is greatly appreciated.
Thanks in advance.
Vick
I would like to know if anybody can help me with this.
I am trying to implement an unique constrains using composite key(two columns)
in Access 2000.
For Eg. I have a table called UserItem with Columns UserId and ItemId.
And the Relation between these two entities is many-to-many.
So in the table UserItem the combination of UserId and ItemId should be unique.
I do not know how to implement this composite key unique constrains in the Access table.
Any help is greatly appreciated.
Thanks in advance.
Vick
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept question, points to TheAmigo
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
1William
EE Cleanup Volunteer