Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.