Radicore Forum: How To » displaying many to many relationships

Home » RADICORE » How To » displaying many to many relationships

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

displaying many to many relationships [message #507]

Wed, 27 December 2006 18:58

David Lee
Messages: 44
Registered: June 2006

Member

If the inner table of a many to many relationship has 100 rows, the resulting link display will have 100 rows. This is not user friendly if only 2 of these possible links are active. Although Tutorial 5 does show how to filter to only show the active links, is there any alternative display possible?
Alternatively, is it possible to have an "create extra link" option on the filtered link table?

Thanks
David Lee

Report message to a moderator

Re: displaying many to many relationships [message #509 is a reply to message #507]

Thu, 28 December 2006 06:00

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

If you look at http://www.tonymarston.net/php-mysql/dialog-types.html#choos e.link1.list2.multi2 you will see that there are in fact 3 ways to display a many-to-many relationship, so you have to choose which one is suitable for you.

There are working examples of these alternatives in the RBAC system so you can see them in action - from the 'List Tasks' screen you will see 3 ways of displaying navigation buttons, and from the 'List Menus' screen you will see 3 ways of displaying menu items.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Previous Topic:	Tutorial - problem??
Next Topic:	many to many and field names

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Jul 06 15:26:22 EDT 2025

Total time taken to generate the page: 0.01061 seconds