Radicore Forum: How To » How to make enquire 1 show child records in many to many relationship

Home » RADICORE » How To » How to make enquire 1 show child records in many to many relationship

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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: 2371
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

Report message to a moderator

[Message index]

		How to make enquire 1 show child records in many to many relationship By: bonzo_bcn on Tue, 15 July 2008 08:53
		Re: How to make enquire 1 show child records in many to many relationship By: AJM on Fri, 18 July 2008 07:10

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Nov 29 00:46:47 EST 2024

Total time taken to generate the page: 0.06909 seconds