I have 2 lists: listA and listB
listA has 2 fields:
listB has 3 fields:
- Title (text),
- listAField(lookup to listA Title field)
- UserID (text)
I have a UserID value and I need a quick way to get PortalID value.
Currently I'm using 2 SPQueries:
- Gets listAField value
- Gets PortalID value.
Is it possible to relate everything using one lookup directly?