Oh and also, because patients will be admitted more than once throughout the clinic I have used the autonumber field.
I've been suggested to have a main form with patient details and subforms for other sections of a clinical form which have an autoID variable and study number variable (primary...