Pretty Sure the Lookup Table is the Problem - Can't See Text, Just See Numbers

[PinkDuster]

I have a report to view items sold in date order, grouped by month and also by transaction type. Used a lookup function in the Orders table to describe transaction type (before I learned this wasn't necessarily a good idea). My report shows the numerical ID for the transaction type, and I want it to show the text.



Tried using DLookup for the Control Source in the text box for TxnType (as shown below) and got the following result, in which ALL the different transaction types are now call the same thing.


Took a different approach and re-created the query to include the Lookup table, but get similar results.

But the query now duplicates each order, showing each of them with each of the different transaction types.

Is there any correction, or should I redo the table structure to get rid of using a lookup table?

[ranman256]

dont use Dlookup in reports or queries. The query IS the Dlookup by joining the data table to the lookup table.

ie: join the tClient.State to tStates.ST to get tStates.StateName

[Minty]

Yup. Get Rid. Recreate your own to do the job properly.

There is nothing wrong with lookup tables you create and use normally, just M$'s implementation of it that leaves a lot to go wrong / confuse the natives.