Creating an Index

[aziz rasul]

I use the following code: -

    CurrentDb.Execute "CREATE INDEX PrimaryKey ON tblContractCountry ([ProductIDprod],[CountryCode],[Contract]);"

which creates the index OK. How do I amend the code so that the Unique index property is set to True?

 

[Jacob Mathai]

try

CREATE UNIQUE INDEX ....................

 

[aziz rasul]

Many thanks.