I need to create a unique index in a table containing two fields, batch_ID and Product_ID. For each batch, a product should only be submitted one time this should be a unique identifier, a candidate key of sorts I believe. I've received instructions on how to do this, but I'm having trouble. When I click on the index window it pops up with the primary key (auto-number) and several other fields. It won't let me remove the primary key from the list of fields due to existing relationships. How do I create an index with just those two fields?
p.s. I don't want to change my primary key, I just want to enforce the composite index. I hope that's clear.