I have a survey table that uses the question number as the field name. I would like to set the caption property of each of the fields to the actual question. I have a table named Facility with two fields, Number and Question. Each Number is also a field name in a table named AllData. I want to use the corresponding Question as the caption for the field Number. I know I can copy and paste the information in the table design view, but this doesn't seem like it should be necessary.