Name Changes

[Andre Adams]

Hey guys.

I want to know. I have a table with all of my individual transaction data
that has a field named "Money Manager". This field is linked to another
table that has a list of Money Managers that I can choose in a drop down
menu. My question is this. If one of my Managers changes their name, how
would I pull historical data, within a query, (and even current data) for
this manager? Would their be a way to combine both names to come up with the
data?

 

[George Nicholson]

Generally, the answer would be to give each of your money managers a unique
ID that will never change, and link the tables via that. The mmName is the
publically exposed value, and can be changed. The mmID is what really
connects everything "under the hood".