Soccer Database trouble

[Anonymous]

I have a soccer database that contains the fields :

MatchNumber- Date - HomeTeam - HomeGoals - VisitorTeam - VisitorGoals

The teams that appear in HomeTeam  and VisitorTeam are the same because some teams may play as home and sometimes plays as visitor.

Need to put in a list box with the two fields (HomeTeam and VisitorTeam) so that when I select the team "A" show me data from home and Visitor.

[Gysbert_Wassenaar]

Load your data like this:

Matches:

LOAD MatchNumber, Date, HomeTeam as Team, HomeGoals as Goals, 'Home' as HomeVisitor

FROM ...

Concatenate(Matches)

LOAD MatchNumber, Date, VisitorTeam as Team, VisitorGoals as Goals, 'Visitor' as HomeVisitor

FROM ...