Column Name Probelm - Weird Scenario Due to Bad Design... :(

[d088]

Guys,

I have volunteered to assist a local non-profit add some functionality to their existing website. (I had a few too many drinks before a meeting...) The site is ASP Classic vbscript with a Access 2000 backend. Overall the site was done well, but there is one design issue that is causing me problems. I'll do my best to explain.

tblContact
pkContactID (replicationID)
firstName (text)
lastName (text)
etc, etc (...)
function01 (byte)
function02 (byte)
...
function25 (byte)

tblFunction
pkFunctionID
description

In tblFunction the IDs are function01, function02,... function25 and the description field is the titles of each function, such as "Email Distribution", "Membership Committee", "Teacher Appreciation Committee".

I am trying to create an export feature so that the group can generate lists but the column names of function01, function02 mean nothing to them.



I thought about redesigning the table structure to use reference tables, but it would cause multiple problems with the existing website features, and I don't drink nearly enough to volunteer to redo everything.

Is there a way to dynamically rename the columns in a query based on the column name being equal to the ID field in another table???

Any assistance would be GREATLY appreciated!

[TheShabz]

To start off with, my knowledge of ASP is nil. logic-wise though it cant be much different than how forms work in Access.
If my assumption is correct, you can pull both the IDs and the descriptions and just use the descriptions as the labels. The user will see the label masking the actual functionxx and you wont need to rename anything.