none
List Relationship in Sharepoint Designer

    Question

  • Hi all,

    I already create the 2 list in SharePoint. How can i relate the 2 list at the same time>? For the example, User have to fill the first list for their details. And they can create more that 1 for the 2nd list. How can i do that?

    Please help me. Thank you..

    Friday, February 09, 2018 7:57 AM

All replies

  • create a lookup field in list 2, link to list 1's title.

    Justin Liu Office Servers and Services MVP, MCSE
    Senior Software Engineer
    Please Vote and Mark as Answer if it helps you.

    Friday, February 09, 2018 8:16 AM
  • Hi Thanks for reply.

    Can i know, its that user have to choose to fill up the list 2?

    Please help me.. Thank you...

    Friday, February 09, 2018 8:26 AM
  • Hey

    The two lists are separately.

    When user choose to fill up list 2, he can choose info from list 1 in the lookup field. Or he can just fill list 1.


    Justin Liu Office Servers and Services MVP, MCSE
    Senior Software Engineer
    Please Vote and Mark as Answer if it helps you.

    Friday, February 09, 2018 8:29 AM
  • Hi Thanks for reply.

    Did u have any example or tutorial for do that?

    Please help me. Thank you..

    Friday, February 09, 2018 9:06 AM
  • Hi Unique- create a new column in the list. For column type, choose lookup. Select the list and column that you want to get the value from.

    cameron rautmann

    Friday, February 09, 2018 1:55 PM