Ok. Here's my problem. We have a field out there called CDC-Id. It's the only identifier that we CAN and DO have for a patient. The CDCID is system generated on the center's end (which are all over the nation). The submit the forms to us and we input them into the system. Now two things can happen....as you very well can already guess, 1. the nurse/user on the center's end can enter in the wrong id and/or 2. the data entry person who receives the form can enter in the wrong id.

When this happens, we must go into the system and make the changes to the cdc id. Now if we make this the primary key, doesn't this mean that we won't be able to update it?

TIA

Jeff t.