Microsoft Access- How do I Make a query or report pull up a field in the same record

[crackerjeffbox]

I have a mock access database that I'm creating for a school project, it's about a prison system.

I want to create a Query that will look up a related "offense code" that I have established relationships, and show that, however instead of showing the offense code, I have another field next to the code that says what the offense actually is, rather than the code. How would I present this instead of the code?

[Rabbit]

I don't think I fully understand what you're trying to say. Just drag the field you want into the query.