Topic: How to generate automatic unique ID number for patients?
I'm trying to build a patient out-patient registration database. Each patient needs to have a unique ID number (PID) that auto-updates with each new record. I have tried to place a record_counter field in the database and linked it to a textbox captioned PID, in the form OPD Registration. But this field does not auto-update when a new record is created. I also tried to use a calculated field as PID in the table and linked the same to the PID field of the form, but with no success. PID may be like A000001, A000002...., which may be possible with a calculated field. Please help.