My SW company was bought by another SQ company about 18 months ago. So we had to build a system to extract data from the old DB to the new one. It's SW to track residents in nursing homes. As part of it we have converted over 600 clients so far. We found a large problem in how the the development created the front end. They allowed the end user to put new vendors, relative contacts types, education levels, religions, etc. on the fly. There is an option to limit who can do that, but is turned off by default. :crying:

So we have gotten DBs that have 175 relation contacts with 25 being different ways to spell or abbreviate daughter. The race codes have countries of origin. There was one that had 125 education levels. The vendor or doctor will be repeated 5 times. :w00t:

Where if the user had to go to a central place to add/modify the setups the users would have probably looked at the preset lists before making a change.