>>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.
I tried this option, the problem is I am appending new records to the team id / Player id table. When I created a view with the Id's and the players name and appended a record it attempted to append a new record to the player table in addition to the team id / player id table.