Use "FieldName" in query

[deltaair]

Is there a way I can use a fieldname in a query.

Like I have a table with Section Number and Section Names. I also have a table with Question Number and Section Numbers. Then I have a table with Question Number, and names of different categories. These categories are the fieldnames for a "Masterdata" table. I need to know if I can use a query or something to link the fieldname in the masterdata with the question numbers.

 

[lespaul]

do you mean:

Table1
SectionNumber           SectionName
1                       Introduction
2                       Section One

Table2
QuestionNumber          SectionNumber
1                           1
2                           1
3                           2
4                           2

Table3
QuestionNumber           Categories
1                          Name
2                          Address

MasterData
Name                     Address
data                     data

and you want results like???

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design