I have a tbl called FishDetails where I enter details on the capture of fish for the surveys that I conduct. On this form I have a combo box that uses a look up table called TblZones to select which part of the river the fish was caught e.g zone1, zone2 etc
I created a query that joins TblAnglers and tblFishDetails to show who caught what. My problem is that when I create a pivot table or any reports the Zone location is displayed as the ZoneID not the Zone location as e.g Zone1, but as 1 instead.
If I email my DB, can some have look and see what Im doing wrong.