Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » How To » How to make enquire 1 show child records in many to many relationship
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 Go to previous message
AJM is currently offline  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.


 
Read Message
Read Message
Previous Topic: How ro remove the 'page created in' message
Next Topic: Display lookup values in list1
Goto Forum:
  


Current Time: Sun Nov 03 09:36:11 EST 2024

Total time taken to generate the page: 0.01344 seconds