I use Access to track charges made on company credit
cards.  When I set up the tables, I considered linking
each card with a particular user, but then decided against
that because the cards can change hands as employees are
added, terminated, moved around, etc.  If I linked a
specific card to a specific user, when a card was re-
assigned and I changed the user, it would update all
records for that card and show the new user for all
previous transactions, correct?  I wanted to have the
correct card-user's name listed for each transaction,
including past transactions.

... I chose instead to have a lookup table to employee
names, and select the current user from that list.  But
now I am getting tired of having to select the name for
every single transaction for every single card.  With
about $50,000 per month on 14 cards with a dozen users
it's very tedious!  The cards don't change hands very
often, so it is really wasteful to not have it automated,
but then again, I can't just have a bunch of inaccurate
records when they DO change hands.

Is there a way that I can link a card to it's current
user, but also keep track of who had it before?  So that
when I go to enter Transaction# 119 for Card01, John
Smith's name automatically fills in, but in 2 months when
Jane Doe is carrying the card, I can change something
somewhere so that her name fills in when I enter her
transactions, but Transaction# 119 still shows John
Smith?  I am open to any and all suggestions, although I
have to ask, "please be gentle" -- I am pretty good with
tables, forms, and reports, but know almost nothing about
Access programming or macros.

Thank you!!