I am looking for a way to create a unique counter on a form that is the composite of the following elements:
1. String like 'GAR_'
2. Login Account on PC like BVH
3. Primary key value of the current record (= the autonumber on the form)
This would lead to an unique identifiable code like:
'GAR_BVH_1233'
This code is to be stored in the same table as rest of the data on the form.
Can this be done?
T. Blom
Information analyst
tbl@shimano-eu.com
1. String like 'GAR_'
2. Login Account on PC like BVH
3. Primary key value of the current record (= the autonumber on the form)
This would lead to an unique identifiable code like:
'GAR_BVH_1233'
This code is to be stored in the same table as rest of the data on the form.
Can this be done?
T. Blom
Information analyst
tbl@shimano-eu.com