now you don't NEED to store that combined result, you WANT to...
store it as 3 separte columns, you cna alwasy merge it as required alter on
select [doc type] + ", " + [doc discipline] + ", " + [doc location] as myconatenatedstring from mytable
but then again if you were following principles of realtional design you'd probably have a table for :-
document types, with the PK of that table azs a FK in you current table.
have a table for disciplines
a table for locations
each of those tabels would have its FK in your table, and you'd probably use a combo or list box to select the correct PK as the FK in your main table.
if you must persist in your current design (and it will be a problem) thneb create a column in your table called say, mybastrdisedtabledesign
set the row source of the current unbound control to be =mybastrdisedtabledesign
then set the value of that control to be =[doc type] + ", " + [doc discipline] + ", " + [doc location].
why do it the 'rogth' way
well what happens if you want to edit the location
or you want to search the location....
doing it your way leaves your system wide open to problems through typos eg simple spelling mishtakes
I'd rather be riding on the Tiger 800 or the Norton