ALB
2
Hey @gehrig,
Off the top of my head, I think you might want to use Merged With on two queries for the Choices Source.
The first query would be for Away Team. The second query would be for Home Team. Put Merged With in between them and it should give you a list of both for each row.
So, right at where it says (more) in your image, add Merged With. Then after that, do Current cell’s Table 1’s Home Team.
Haven’t tested this, but I think that’s what I would try.
Cheers,
Al