I think I'm having a brain cramp on this. I have a single query that I am trying to design for some transactions that I am trying to report on. Initially, the query included a field from my main table that showed a code for the "From Location" and another field for the "To Location". I just added another table that has all of the location codes in a single column, followed by the Names of the locations in another field.
I want to design my query to tie in the From Location Name, and the To Location Name. In design query, I have 2 fields from my main table tied to a single field in the second table, but I don't think that will work and am not sure what to do.