Radicore Forum: How To » many-to-many

Home » RADICORE » How To » many-to-many

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

many-to-many [message #766]

Thu, 12 April 2007 15:56

interop
Messages: 45
Registered: October 2006

Member

I have a few many-to-many relationships defined as follows:

employee -> employee_address <- address
company -> company_address <- address
contact -> contact_address <- address

Displaying this information with list2 is not a problem but adding a new address to an employee, company, or contact is cumbersome because the address table contains approximately 5000 rows.

Is there a way to make this situation easier within the framework or possibly a better schema design?

Report message to a moderator

Re: many-to-many [message #767 is a reply to message #766]

Thu, 12 April 2007 18:42

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

Senior Member

In the framework I have two examples of many-to-many relationships, with 3 different ways of maintaining them. Go to List Task (Proc) and check out Maintain Navigation Buttons 1, 2 and 3, and also List Task (Menu) and Menu Items 1, 2 and 3. Just play with them then pick the flavour that you like the best.

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

Report message to a moderator

Previous Topic:	Business Rules Best Practice
Next Topic:	Display field from Related table 2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Jul 06 04:13:03 EDT 2025

Total time taken to generate the page: 0.09845 seconds