Sara

Just because a resident moves out, doesn't mean the SQL database necessarily
deletes that resident. If I were designing a "residency" database, I would
want to keep information on former residents. You may wish to pursue this a
little further, as you will run into potential synchronization issues as
soon as you begin storing more than one copy of the same info.

--
Good luck

Jeff Boyce
Access MVP