MX Looper Forum :: Nested repeat region but based on three tables

This thread was displayed: 0 times


Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.

For more information about the affected products visit: www.interaktonline.com/Support/

View Threaded Show descending
Dries Coucke
03-26-2007 17:59:18 GMT +2

(Please do not confuse this with a three level nested repeat region)

I try to build a community site where users can become friends of other users. Each user has a list of favorite books. On the profile page of each user, i want to show the friends of that user and the favorite books of that friend.

My database has three tables:

USERS (UserID,...)
USERS_FRIENDS (ID, UserID, FriendID)
BOOKS (UniqueID, UserID, BookID,...)

I want to show this:

USER PROFILE PAGE
Welcome to my books and friends profile page. I am user ABC!

My friends and their favorite books are:

FRIEND 1 : BOOK X, BOOK Z
FRIEND 2 : BOOK C, BOOK P
FRIEND 3 : BOOK K

I can easily retrieve this data using a query based on a URL parameter, but I do not manage to show it grouped per friend. (The display repeats the friends name for every book)

All recommendations are more than welcome!

Dries

 
Back | Reply | Quote | Top
Ionut MOICIANU
04-04-2007 12:15:09 GMT +2

Hello,

This should be rather simple - apply the Nested Repeat Region Wizard using the friends and books tables, set to display as "List", then edit the friends Recordset and filter it by user ID url parameter (or "kt_login_id" session variable).

Regards,
Ionut
Reply | Quote | Top
Messages 1 to 1 from 1
Forums
MX Looper 3.7.1
© Adobe Systems Romania. All rights reserved.