Forums

I have a connection setup for the tables Users, Users_info, and jlike_like_lists

User (model name Givver) > Users_info (model name Profile) is one to one (Givver.id=Profile.id)

User_info > jlike_like_lists (model name List) is one to many

If I make it one to one I get a list of everything, see image attached (that's what I get, it's marked up with what I want. I want the output grouped).

If I do it as one to many - I get nothing returned in the jlike column (foreign key set to user_id, join is inner, hierchical - I've tried both yes and no) join rule Profile.id=List.user_id. I've tried putting the field list in List.title - that doesn't work either.

Help! thanks ;-)

Hi Lydia,

Do it as one to many and in the "List.title" please use this field name:

List.[n].title OR List.{n}.title, whatever works for you.

Regards,
Max

thanks! Worked great.