How can you dynamically set a SQL field name based on a concatenation of fields from other tables?
===

I have two tables. The field names in the projects table are stored in the fieldname table

###Projects Table###

<pre>RecordID, ProjectID, Field1, Field2, Field3, Field4,...,Field20</pre>

###FieldNames Table###

<pre>FieldNameID, ProjectID, FieldNumber, FieldName</pre>

Is it possible to return results from the Projects table where the field name is actually FieldNames.FieldName? Can you concatenate 'Field'+FieldNames.FieldNumber to return the Fieldname and then use that as the alias for Field(x) in Projects?

ie: instead of  "Field1" it would be FieldNames.FieldName where Projects.ProjectID=FieldNames.ProjectNames and FieldNumber=1 

 