>I need to create a primary key compound by two fields. I was trying to do that in the GUI but it doesn't work (i.e. Field1 + Field2).
>
>Then I found this in the MSDN Online library:
> ALTER TABLE MyTable ADD PRIMARY KEY Field1 tag Field1
>
>How can I to include two fields in the above statement?
>
>
>Thanks all!!!

ALTER TABLE MyTable ADD PRIMARY KEY Field1 + Field2 tag PK

See bold above. You can also keep the index tag name the same as Field1 but that could get confusing.

HTH.