ms access - Column name based on another column's value -

i have table 4 columns in access. column names [index,department,column1,column2]. "column1" , "column2"'s name can vary depending on department. efficient , intuitive way display multiple column names "column1" , "column2" based on department?

index   department  column1 column2 1             dpta   123    345 2             dptb   456    hello 3             dptc   789    world 

the problem may confusing glad answer questions. thank you!

sounds you'll need code in background change field's labels on forms. can't imagine want change field names in base table.

changing labels on forms pretty simple though:

if me.department = "dpta" me.column1label = "whatever" end if

...where department name of control value department , column1label label control's name on form.