**The Profile Affiliation record has NO-LOCK status. Delete not allowed. (335)

The following error appears while trying to delete an affiliation code from the code table:  ** The Profile Affiliation record has NO-LOCK status.  DELETE not allowed (335).  

Steps to Duplicate:

1) Log into FIMS

2) Go to Profiles

3) Click on File Maintenance>Profile Code Maintenance>Affiliation

4) Click on affiliation code you want to delete (one that has member codes)

5) Click the delete button (Black X)

6) Error occurs

Answer:

If an affiliation code has members, it is not able to be deleted from the affiliation code table in Profiles>File Maintenance>Profile Code Maintenance>Affiliation.

How do I delete an affiliation code from the code table?