Past Records Tracking

[kevin watkins]

Shannon,

Why would you want to move them is my first question? I
would leave them alone and create a new field that is a
check box as to being active or not. Then when dealing
with records you could use this to be part of your
criteria. Otherwise you need to use append queries and
stuff to move records, or macros etc. I find it easier to
just simply have a box that I would check to list them as
in-active. Then if you want to keep track of there new
address you could put this in a new table and have the
relationship connect them so that if you want to find
there new address or phone you could do this easily.

Hope this helps

Kevin

 

[Shannon]

The problem is that the address is the key to the
Property table. When the person moves, the address
information remains the same and the owner changes. This
is a housing association database. Any ideas?

Shannon

 

[Gina Whipp]

As Kevin said you will need to write an append query that sends the name,
and perhaps the dates to and fro that they lived there, to another table.
Set up a relationship of one to many in the other table so you can look up
previous owners should you have to.

Hope that makes sense...
Gina