Am building a clinic database using access 2007 which will be used in 5 different centers, on the registration form, there is a field that caputers the name of the health center first, then the patient ID comes next.
Is it possible to select a name of the health center and an input mask containing the first 3 letters of the center comes up automatically in the patient ID field.
the IDs are like KSY/00001, KIS/00001, WSA/00001 etc
Thanx for any help!
Is it possible to select a name of the health center and an input mask containing the first 3 letters of the center comes up automatically in the patient ID field.
the IDs are like KSY/00001, KIS/00001, WSA/00001 etc
Thanx for any help!