Multiple input masks?

[Mayanja_N]

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!

 

[John Big Booty]

Perhaps the attached sample will give you some pointers.

 

[Galaxiom]

I would not record those three letters in the code but use the fields for HealthCenterID and a numeric PatientID as a composite key.

The combined Center/Patient ID would be generated for display only.

You would want to record the HealthCenterID of the patient in its own field anyway and including the HealthCenterID in the PatientID as well is technically a breach of normalization.