Kate,

As a side note, your "changing doctor(GP)" note implies that the doctor's
name is a part of your mission/question, but you didn't tell us anything
about that.

Another question: Do your have a requirement for recording a then-current
address for each test? Let's assume not.

Also, a cornerstone of this will be to have each patient uniquely /
correctly identified with a number, and have only one "patient" entry for
eadch patient. You have described a path you are taking to that point.
Let's assume that you have already accomplished this.

The this is going to have to start with you making a decision between Plan
"A" and plan"B". "B" is more work; you need to decided if it is necessary
or sufficiently useful to retain previous addresses.


Plan "A": Just keep a single address in the patient record/table, and keep
it current.

Plan "B" Make a second address table, and link it's entries to the patient
table on a PatientIDNumber field. Include a "CurrentLocation" field where
entery of a ""Y" (Yes) indicatres that that is their current address.

Hope that helps a little.

Fred