I have had this problem throught the years, and can never seem to figure out how to fix it. I don't know why Access continues to have this quirk.
I have a query called "Find Encore Velour Orders", and it works great.
When I created a report based on it, my field "Description" shows up as the record number from the Products table, not the text description of the product.
I have tried many attempts to solve, and the forums just confuse me more.
I do understand that in my table "Orders" I am using a lookup field and I know I should not do that. But, I always forget that rule when creating databases.
I am attaching a zipped version of my database.
Any pointers would be greatly appreciated! My technical jargon is not that great. Thanks! Specialty Drape.zip