Can someone explain how I can make a combination of two fields be a
unique index.
For example, in my table I have an OrderID field and a LineItems field.
Individually the fields are not unique but when combined they are. I'd
like to create a unique index of the two together but not individually
ALTER TABLE tablename ADD UNIQUE (Column1, Column2);
Best Regards,
Andrew
Can someone explain how I can make a combination of two fields be a
unique index.
For example, in my table I have an OrderID field and a LineItems field.
Individually the fields are not unique but when combined