Removing Disabled Users from Choice Lists
Instead of deleting users from the users database, you can prevent the Owner and Contact lists from showing disabled users. However, if an existing issue references the user in its Owner or Contact field, the field will be empty.
To remove disabled users from choice lists:
1 Open the project definitions database.
2 Open tblDtsFields and find the owner (nID = 11) and contact (nID = 13) records.
3 In the tWhere field, add And fDeleted = 0 to the Where clause. For example:
Where (([nID] >= 0 And [tName] <> '') Or [tName] = '<User>') And fOriginator = 0 And fDeleted = 0