Generating a barcode number in a table and form

[RTKarkivi]

Hello,


I have a form based on the table with these fields:
1. Fixed asset number (ex. 354)
2. Asset category (three characters, ex.107)
3. Location of the asset (two options: Television or Radio)
4. Origin of the asset (two options: Donation or Investment)
5. Barcode number



What I want, is automatic generating a 10 character barcode number consisting of the following data:
- First character of the location (ex. “T” for Television, and “R” for Radio)
- Three characters of the asset category (ex. 107)
- First character of the origin (ex. “D” for Donation and “I” for Investment)
- Five characters from the Asset Number (ex. 00354 for 354)


I count on your support.


Thanks,
Hysen

 

[HenryAnthony]

Can you not just concatenate the various fields in a text box on your form?