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
>-----Original Message-----
>How can I have a record go to another table when it is
>deleted? This would keep track of property owners after
>they move from this associated community.
>.
>

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
>-----Original Message-----
>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
>>-----Original Message-----
>>How can I have a record go to another table when it is
>>deleted? This would keep track of property owners after
>>they move from this associated community.
>>.
>>
>.
>

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

"Shannon" <(E-Mail Removed)> wrote in message
news:0f4201c38882$9e36e6b0$(E-Mail Removed)...
> 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
> >-----Original Message-----
> >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
> >>-----Original Message-----
> >>How can I have a record go to another table when it is
> >>deleted? This would keep track of property owners after
> >>they move from this associated community.
> >>.
> >>
> >.
> >