I've inherited an Access database that has sort of cryptic column names. The reason (I think) is because the actual column names that get displayed on the web page are long, and have quotes and parens in them, so whoever built the thing abbreviated the column names by using the first letter of each word.
Anyway, since no one can remember which column is which, I added a table to the database that has a column for the names, and a column containing the descriptions, so whoever updates the thing can refer to that table to figure out which column is which.
Right now, the column names are hard-coded on the web page, but I'd rather fetch them out of the database. The problem is, I don't know any way of joining a row in my table with a column name in the old table.