Re: How to generate automatic unique ID number for patients?
Hello Derek & Jean,
Thanks again for making the concepts clear. I would like to close AA_Form_007_OPD_VISIT_REC immediately after saving to ensure that OPD_ID is properly saved, but I need to enter details of the visit for the new generated OPD_ID in the same form (though different tables). However, if the form is closed at the same time as saving, how the details can be entered? Should I close the form and use the Edit button in AA_Form_006_PATIENT_REG_REC to return to AA_Form_007_OPD_VISIT_REC and record visit details?
Thank you Jean for the code. As both Derek and you too have suggested, maybe the best way would be to close the form and return via the Edit button.
I would follow your advice to delete the test records.
Regards,
eyeman303