- This topic is empty.
- 01/22/2014 at 12:53 pm #4730
My set up is as follows:
RID (unique key)
RID (foreign key)
PID (foreign key)
PID (unique key)
This is essentially mapping a N-N relationship between lists.
I have List 1 displayed in a list view filtered based on a querystring. The filter is based on the RID. What I’ve done next is create another list view with List 2 as the primary list and List 3 as the child list with the PID values linking. List 2 is also filtered on RID. When I do this I’m getting the appropiate values to display for List 2 but when I expand the child view there are no items displayed (and there should be).
Following the tutorials this should provide me with what I need but I’m not quite sure where things are going wrong.
A second question, if I manage to get this solution working, am I able to display all child values only and hide the parent?
- 01/22/2014 at 12:53 pm #5504
Okay I managed to fix this myself. After spending half the day yesterday and most of this morning.
What I was doing was in List 2 RID and PID were lookup values from List 1 and List 3. However in List 1 and List 3 RID/PID were text strings so what I was doing was basically comparing a lookup with a text string. Even though the text of the lookup was the same it wouldn't link them.
RID: 0001 (link to List 1 element)
PID: 0001 (link to List 3 element)
You must be logged in to reply to this topic.