field displays wrong info

[Royboy]

I have built this handy little database that ive named "Frieght Master" I use this to record piece counts and weight of items of freight that I pick up in Boston ( all seafood by the way) Anyhow here is the problem I'm having. Anytime I create a report one of my field names (RECIVER) keeps displaying as a unique number. Example, "New Enland Fish Market" display's as "14" which is its auto number assigned to it when I created the Table of recievers. I have struggled with this for so long... its really inhibiting my goal of making this a really good tool for me. Any help will be very much appreciated! Thanks, Royboy

 

[John Big Booty]

Welcome to the forum.

Are you using table level lookups? This could be causing your problem.

 

[Galaxiom]

Two solutions:

1. Join the lookup table into the query and use the name instead of the ID field.
2. Change the textbox to a combobox and set its columns to display the name instead of the ID.

 

[Royboy]

Thanks mates!