var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Newbie report question
I've two tables
PlayerID - PK
GameID - PK
How do i make it appear in the Report, instead of Player1_ID and Player2_ID the PlayerName?
My logic so far is something like: SELECT Players.PlayerName FROM Players WHERE PlayerID=Player1_ID;
SELECT Players.PlayerName FROM Players WHERE PlayerID=Player2_ID;
Make these 2 qrys and use them in the report instead of the Player1 and Player2 ID values.
But, for 1, i've no idea how or where i put this query in the report, and 2 i've no idea how to associate 2 qrys to one report via wizard.
Select the Query Builder button that pops up when you click onto the Record Source property for your report. From this builder you can add whatever tables you like and set whatever criteria is necessary. You can make your report dance......well, not really.
PS: You may want to consider using only a single entry for each player in your games table. You can pull them together by game id later.
Then your select query becomes:
SELECT PlayerName, Score FROM Players INNER JOIN Games ON Players.Player_id = Games.Player_id
WHERE Games.game_id = GAMEid_YOU_WANT_INFO_FROM_GOES_HERE