I'm trying to build a report from a table with composite keys where both keys reference the same table. What I need in my report is to show a value from the referenced table for both keys. F. ex if I have a composite key ckey1 = 1, ckey2 = 2 and key = 1 has value a and key = 2 has value b in the referenced table I need my report to show {ckey 1 = 1, value = a, ckey 2 = 2, value b}.



I tried the report wizard and from that managed to get a report that shows me a value for the first key but I don't know how to get values for them both since they are from the same table.

Please help a access/database newbie .