quick way to access splistitem in different list?

Question

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 do everything using one lookup directly? or some other more efficient way ?

score 1 · Answer 1 · answered Apr 15 '13 at 13:10

1

you can use SPServices for this, using cascading dropdowns, you can find more info here: http://www.sharepointkings.com/2010/09/sharepoint-cascading-drop-downs-using.html this saved my life a lot of times already.

answered Apr 15 '13 at 13:10

Angelo Kee

score 0 · Answer 2 · answered Apr 15 '13 at 12:02

0

when you are making lookup you can check which fields from list A you want to come with title. Just check checkbox with field PortalID

answered Apr 15 '13 at 12:02

Sebastian 506563

2 Answers2