Well, your first problem is you have the customer name in your database more
than one time. In a properly normalized database, the customer name would be
in one field in one table. That table should have an autonumber primary key
and that key value should be used in related tables rather than the actual
name. Then, each place you need to see the customer name, you would use a
query that would join the customer table to the other tables to present the
name.
Now, all you need to do for now (that is until you normalize your database)
is to run an update query on every table where the customer name would be
that would replace the old name with the new:
UPDATE MyTable SET [CustomerName] = "New Name" WHERE [CustomerName] =
"Old Name"
