Hello,
This might be an obvious one but am stuck.
I have 2 tables and a junction table. Table 1 is Countries, Table 2 is Activities.
Table 1
CountryName CountryID United Kingdom UK_001 Ireland IR_001 Denmark DM_001 France FR_001
Table 2
Activity ActivityID Football FB_001 Golf GF_001 Tennis TN_001
Junction Table:
CountryID ActivityID IR_001 GF_001 IR_001 TN_001 UK_001 FB_001 UK_001 TN_001 DM_001 FB_001 DM_001 TN_001 FR_001 GF_001 FR_001 FB_001 FR_001 TN_001
How can I produce a report that looks like this, with the matching activities on each row so I can compare? Or can I have a nudge in the right direction?
United Kingdom Ireland Denmark France GF_001 GF_001 FB_001 FB_001 FB_001 TN_001 TN_001 TN_001 TN_001
Thank you,
EffBee