SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have 2 lists: listA and listB

listA has 2 fields:

  • Title (text)

  • PortalID (text)

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:

  1. Gets listAField value
  2. Gets PortalID value.

Is it possible to relate everything using one lookup directly?

share|improve this question

While creating the lookup column, you can use additional column settings to include the additional field PortalID. This will allow you to use one query only.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.