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...