Report showing ID field rather than Text

[daveUK]

Hi

I have 2 tables in the database I'm currently creating. TblRegion, which stores the region the employee works in, and TblStaffDetails, which stores their contact details.

I have the region field in tblStaffDetails, which is a lookup combo box from TblRegion.

I have a dynamic report, which allows users to select which fields they wish to view by using a list box. This report is based on a query, which is based on TblStaffDetails.

Now for my question:

When the rport is displayed, the region field is displayed as a number (the RegionID) rather than text!! The strange thing is, is that if I view the query, the region field is displayed correctly as text

I'm sure there is something that I'm missing, but I've been playing with this for 2 hours now and it's starting to annoy me.

Thanks in advance

 

[Malcy]

Sorry but might be missing something.
You say the query is displaying the right result but the report isn't.
Would be worth checking that the textbox in the report is sourced from the correct query field. It sounds like you are referencing the region ID rather than the text.
If so, then dead easy to solve. If not, then would need a little more info.
HTH

 

[daveUK]

Thanks for the reply.

Yeah, I know it sounds strange. The txtbox on the report is definately sourced to the RegionName and not to RegionID, so it should display the correct values.

I can't understand why the qry is ok, but the report isn't. It's a dynamic qry that changes depending upon the fields the user chooses, but this shouldn't make a difference.

 

[daveUK]

Hi Pat

You're right, the Region field is a lookup in the TblStaffDetails.

I would remove the lookup from the table but of course that is my personal choice since I understand how to use joins to obtain the lookup value and I create the joins as I need them so I have control over whether I see the ID or the text or both.

Have you got an example of how I can use joins to obtain the lookup value?

Thanks

 

[daveUK]

Thanks Pat, I'll give it a go