Dynamic field in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

H

I have this proble

I have a table with a Foreing Key and 241 fields with values (Table 1
I also have a table (Table 2) with a Key and a text field that contains a field name of Table 1 (one of the 241

I must make a Query in the Query Designer with a join of both tables and the value of the field of Table 1 which name appears in Table

Is it possible

Notes:
My customer doesn't want any changes in the tables' structure (that was my first option
I tried the Choose Function but it is too lon
 
Ricardo

The customer is always ... the customer. That doesn't mean the customer is
right. The table structure is almost certainly not well normalized, and, as
a result, will cause the customer (and you) serious headaches trying to do
simple things like queries.

If the customer is paying you, you can point out that it will cost
significantly more, on an ongoing, long-term basis, to "work around" a
poorly-normalized data structure. This sounds like a "pay me now or pay me
later" situation.

I don't know of a way to join a field in one table with the value of a field
in another -- at least, by using the query designer. I suspect you could do
something like this in a code procedure.

Good luck!

Jeff Boyce
<Access MVP>
 
And to emphasize Jeff Boyce's comment.
"Pay me now, or pay me A LOT MORE later. AND keep paying me for changes until
we do normalize the database"
 
Back
Top