AnsweredAssumed Answered

Changing Client Name Changes Connected Data?

Question asked by kopiikat on Oct 7, 2009
Latest reply on Oct 7, 2009 by kopiikat

Title

Changing Client Name Changes Connected Data?

Post

I am new to databases, and just posted the other day, but I'm back with another question.  This one is more specific and, hopefully, less of a pain to answer.  I am trying to manage a database of clients for a non-profit.  It's going well, and I think I'm getting the hang of the basics.  I've run into a problem, though:

 

I created a client, John Doe.  On his "profile," is all sorts of information about his income, how much money we're giving him, etc., which is connected to another table by a portal.  The shared fields are "FIRST" and "LAST" (names.)  I was curious what would happen if I changed his name to "John Smith."  When I did, all of his information remained the same, except for the portals, which were still somehow connected to the name "John Doe."  How could I have it so that I can change a client's name (in case of typos and the like,) and keep the related information still connected?

 

Thanks so much in advance.

Outcomes