fromthecauseway
New member
- Local time
- Today, 07:41
- Joined
- Apr 9, 2020
- Messages
- 3
I'm trying to make a document register where the number is made up of various fields. Discipline, type, number (ME-RPT-0001) which is mechanical report number 1.
I have a tbl_documents which prompts for the discipline and type using combo box lookup from tbl_discipline and tbl_type. This is part of frm_documents. This works. What I want to do is join the 3 fields into 1, either just to display on the form or preferably save as a field in its own right which can then be referenced. I've tried this in the table, form and query but rather than ME-RPT-0001 get 1-1-0001. Can anyone offer some guidance?
I have a tbl_documents which prompts for the discipline and type using combo box lookup from tbl_discipline and tbl_type. This is part of frm_documents. This works. What I want to do is join the 3 fields into 1, either just to display on the form or preferably save as a field in its own right which can then be referenced. I've tried this in the table, form and query but rather than ME-RPT-0001 get 1-1-0001. Can anyone offer some guidance?