to maintain data integrity, we should use a lookup here and not allow the client to type in manually any company name. This will result in multiple different formats. “Coca-Cola, Coke, Coca Cola, Coke Cola Co., Coca Cola Inc”
You won't be notified about changes to this idea.