Alternative to Dlookup?

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Is there an acceptable alternative to using DLookup on a form/subform?
I have a patient listing with multiple transactions. The transactions
are coded as to type. I am now using a DLookup to populate a TextBox to
give English Descriptions for each code. With 500 transactions per
patient, it takes a <long> time for the form to complete itself. Is
there a better way to do this?

TIA

Steve
 
Write a query that joins the two tables so that your incoming recordset
already has the descriptions on it.
 
And base the sub-form on the recordset? I had previously tried that for
the data (as it was in 2 tables) but the query took 20 seconds or more
to materialize, so I joined the 2 tables prior to this. I suppose I
could continue to de-Normalize, but that seems wierd in the name of
speed....

Oh well, this is only a short term project, so I suppose any kludge will
work! <g>

Steve
 
Since you're complaining about how long the query takes when relating the 2
tables, that would seem to be the more important set of indexes.
 
Back
Top