A:  the reason that we have the code user assigned, and not numbers, because through out the system we are using the code to display the manufacturer, rarely we show the actual name  (or description as we call it). If the user decided to upload the code as numbers, that is all they will see on all our screens and reports. For the changing the names of the manufacturer including the code, I believe, we have a utility. All the user has to do is to add new manufacturer and replace the old with the new , then they can remove the old.   This would be found under the <<SQLSYSUTILITY.EXE>>