| 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?
|
|
|
|
| Re: many-to-many [message #767 is a reply to message #766] |
Thu, 12 April 2007 18:42  |
AJM
Messages: 2347
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
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
