How to Change the name of a customer in Access 2003

  • Thread starter Thread starter Elizabeth
  • Start date Start date
E

Elizabeth

I've got a customer who was purchased and now goes by a different name. How
can I change the name of this customer in all their records in the database?
 
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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
Employee Names in Table 3
How do I invoice a cost to a custom built MS Access Accounting Database? 0
Customer Orders Database 2
SQL Question - restated 3
Create New Table/Column 1
Custom titles are active 0
Seperate Email for each record 5

Back
Top