w/ dlookup

[In need of help]

What I am trying to do:
tblUniveral is made of questions (Q1- Q28)which can only
take their value from the list of Satisnumber off the
tblSatisfaction. tblSatisfaction is made up of two columns
Satisnumber and it's corresponding Satisdescription. I am
trying to make a query show the Satisdescription that
corresponds to the satisnumber that applies to the
question. (Show the description that fits the response,
instead of the numeric value.)

What I tried:
DLookUp("[SatisDescription]","tblSatisfaction",
"[SatisNumber]=" & DLookUp("[Q1]","tblUniversal"))
**However, this is giving me the Satisdescription of the
first response and repeating it for every entry.

Any help on changing how I am doing this would be greatly
appreciated!

 

[John Vinson]

What I am trying to do:
tblUniveral is made of questions (Q1- Q28)which can only
take their value from the list of Satisnumber off the
tblSatisfaction. tblSatisfaction is made up of two columns
Satisnumber and it's corresponding Satisdescription. I am
trying to make a query show the Satisdescription that
corresponds to the satisnumber that applies to the
question. (Show the description that fits the response,
instead of the numeric value.)

Don't use DLookUp at all - it's not an efficient way to do this.

Two suggestions:

- Create a Query joining tblUniversal to *twenty-eight* instances of
tblSatisfaction, joining on Q1, Q2, and so on.

- Probably better, display the data on a Form with 28 combo boxes
bound to Q1 - Q28, with tblSatisfaction as the combo's rowsource.