| 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?
|
|
|
|
| Re: How to make enquire 1 show child records in many to many relationship [message #1509 is a reply to message #1469] |
Fri, 18 July 2008 07:10  |
AJM
Messages: 2363
Registered: April 2006
Location: Surrey, UK
|
Senior Member |
|
|
If you are in a LIST1 transaction for table 'team', and you want a navigation button which will show all players within that team, then you must construct a LIST2 transaction which has 'team' as the outer entity and 'team_player_xref' as the inner entity. If you have defined a relationship between 'team_player_xref' and 'player' then you can automatically JOIN to the 'player' table to obtain the player's name.
Look in the Example application at 'List Option for a Selected Person' for a working example.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
