Take a look at the attached screen shot.
1) Click the button circled in red. Alternatively, you can click View->Indexes. This will open a small window such as is shown in the picture.
2) Create a new index by making up a name on a blank line in this new window in the first column. In the second column pick one of the two fields that together makes up this unique index.
3) On the very next line, pick the other field that makes it unique in the second column leaving the first column blank. You should have something that looks like what is circled in blue, though with different names.
4) Click on the first line of this index (the line that has the name of the index in the first column). Make sure to select Unique as is circled in purple.
If you needed an index unique spanning 3 columns, you can continue this pattern. As long as you leave the "Index Name" column blank, it will continue from the line above for the same index.
Let me know what, if anything, doesn't make sense and we'll go from there.
Edited by: babrandt on Wed Sep 7 17:25:56 EDT 2005.