I need to merge a multi-choice prefix field to my ID field and have both fields combined into one field called "FullID" in my table.
The ID field is an auto number, and the prefix choice will come from a drop-down list lookup field in the same table e.g. AA, BB, CC. So the combined FullID will be AA001, AA002, BB003 etc etc.
What would be the best way of doing this? Im thinking a query to merge the two fields, then another query to append into the FullID field, all executed from a macro?