How do I link an unrelated field from a table to a query based report.?

[Victor]

Thanks Terry,

But I already thought about that, but unfortunately it
won't work. The id number and id name is its own table
and rest of the info is in the main table. I created a
relationship from the id number to an id field in the main
table but not for the id name.

With that understanding. My report currently gives the id
number and all the information from the main table that is
related to that id number. Is there another way to get
that id name along side the id number.

Thanks for all of your help.