New answers tagged


The first part of the solution was – as I said in the question – to convert the primary key index into a non-primary index by turning Primary off (and leaving Unique on) in the Indexes window. An alternative means for creating such an index, as suggested by @mpag, is via SQL: CREATE UNIQUE INDEX uidx_engagement ON Engagement (Emp_id, Year, ...

Top 50 recent answers are included