Get Title from a list by storing its Id in another list

mshaji used Ask the Experts™
I have a list named  test1 and another list named test2. The fields in test1 are Id, Title, Body and fields in test2 are Id, test1 Id, Title, Body. Now here i want to make a sp query with test2 list to select Title from test1 list where test1 Id is equal to some value (let's say 1)

Can anybody help me to do this by SharePoint list query
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
One way to do this can be if you add another lookup col in test 2 which will be Title from test 1 .
Make test1ID visible when you create item and display Title (list1) on the default view of list 2 .

Another can be use of InfoPath forms where you can create different view



Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial