Kate,

These guys know Access design better than I do. My strength is on the
implementation and organization of information side.

Just one "30,000' view" note to add. In your 2nd post you in essence said
that, for each test, your need to (amongst other things) record:

- The name or description of the test
- The patient's address at the time f the test
- The Patient's GP at the time of the test.

This means that the above 3 items are fundamentally a part of the test
record. How you get them into / store them in the record can be any of
several ways such as:

- Have theire most recent test record loaded as a default and then editing
it.
- make separate tables for any or all of the above three items, and use a
dropdown list to load the text*
- make separate tables for any or all of the above three items, and use a
dropdown list to load the ID# of the entry, and link to that table to show
the text.*

Or a combination of the above.

* For address, filter the dropdown list to show addresses associated with
the patient.

Sincerely,

Fred