I am having a problem in dealing with column headings in a table, where certain fields have data that needs to go with them.

Right now, I have a seperate table of all the column headings, with another field for "Notes" so I can add data for the field names, but whenever I change the name of a column in the main table, I have to go back to this table and update it also.

Is there a way to pull all of the rows of my FieldNames table from the column headings of my main table? Then whenever I change or add/delete a column in the main table, it will be reflected in the FieldNames table.

Is there a way with SQL or Access? It seems like there would be databases designed where some columns will need to have some data attributes. How is this generally dealt with? Thanks very much for any incite.

Wyn