How to make enquire 1 show child records in many to many relationship [message #1469] |
Tue, 15 July 2008 08:53 |
bonzo_bcn
Messages: 152 Registered: June 2008
|
Senior Member |
|
|
I have three tables:
team
player
team_player_xref (as one player can play in many teams)
I'd like to know if it's possible that when the user clicks the 'read' button on a list 1 transaction for table 'teams', it displays all the players in that team.
I use a link 1 for adding players.
I've tried a list 2 transaction, but then it only shows the data of team_player_xref which is basically a team_id and a player_id.
Any ideas?
|
|
|