Index on 2 columns

[lactaman]

Hi,

I want to have an index such that the combination of "line no" and "calving date" are unique.

I have tried:

CREATE UNIQUE INDEX index1
ON [main table] ([Line no], [Calving Date])
;

And

CREATE INDEX index1
ON [main table] ([Line no], [Calving Date])
WITH PRIMARY;

but I get a unique index on Line no

Any suggestions?

Regards

lactaman

 

[pl456]

Go to the table design view, hold control down and select both fields you want, right click and select primary key.

I think.

 

[lactaman]

Ok

got it working now - thanks