I have the following scenario:
I have 3 tables, one for a list of teams, another for a list of players, and a third for a list of team id's and associated player id's to indicate which players are on which teams. (A player can be on more than one team)
Now when I select a team I have a grid on a form to show the players on that team. I have a view which contains the player id's for the selected team. I want to display the related player data in the grid. Therefore, I have set a relation from the view into the player table. Unfortunately I cannot get the player data to show up in the grid properly.
Since you have to assign one table value as the RecordSource I am at a loss as to how to display data from two tables in the grid. Any suggestions?
TIA, Lee