I have an existing table designed that has a field named PriKey defined as the Primary Key. I need to modify the table and remove the field and set another field (RecID) as the new Primary Key. I have opened 'Modify Table' interface, but the existing PriKey is greyed out, and attempting to delete it results in errors.
How do I go about accomplishing the deletion of this field and setting another field as the primary key for this table?
Thanks
Doug