>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
Create a view from these two tables and use it as a RecordSource.
Edward Pikman
Independent Consultant