PLEASE!! help me with my report

[bobby]

Hello,

My database system tracks football scores such as :
7/6/2004 Arsenal 1 - 3 Liverpool

I have a tblMatch, which tracks the home team ID and the away team ID as well as the date of the match. Tbl clubs contains the id of the club and its name. So:

tblMatch
````````
Home_Club_ID
Away_Club_ID
Play_Date

tblClubs
```````
Club_ID
Club_Name

I want a report two reports. The first one that will output all results from liverpool so it woul dlook like this :

LIVERPOOL
``````````
Liverpool 1 - 2 Manchester united
Liverpool 2 - 0 Leeds
Charlton 3 - 1 Liverpool

Im having trouble however, getting the two clubnames. I can get the the home club id and away club ID from the match table, but i need the resolved clubnames.

--------------------------------------------------------

So i want to use the same field in a table twice. Once to show the NAME of the home club and once to show the name of the AWAY club.

Please help, thanks.

 

[SQL_Hell]

Providing you have a valid relationship set up between the two tables, all you should need to do is create a query to join both tables together, then use the query as your reports record source.

Get that done and we will deal with rest later