Hi,
After creating my unique ID, I am looking to add 1 extra part to it.
I currently have the ID pull back the initials, gender and date of death of patients (eg. ABM09/10) It pulls all this info from various fields on a form and sub form.
What I need it to do now is generate this ID but also factor in a autonumber. So it would look like 1-ABM09/10 or ABM09/10-1, then ABM09/10-2 etc...
I am currently using the autonumber feature as a PK for each record, but would also like to generate this uniqueID as its required for forms between agencies.
Any help?
Thanks
Will
After creating my unique ID, I am looking to add 1 extra part to it.
I currently have the ID pull back the initials, gender and date of death of patients (eg. ABM09/10) It pulls all this info from various fields on a form and sub form.
What I need it to do now is generate this ID but also factor in a autonumber. So it would look like 1-ABM09/10 or ABM09/10-1, then ABM09/10-2 etc...
I am currently using the autonumber feature as a PK for each record, but would also like to generate this uniqueID as its required for forms between agencies.
Any help?
Thanks
Will