How to link 2 sharepoint list

Giang Nguyen 21 Reputation points
2021-01-25T09:19:33.253+00:00

I'm using SharePoint online and wonder if I can link 2 lists.
Given I have the lists: Oders and Order Details.

  1. I created 1 item in the Orders list.
  2. I created 2 items in the Order Details list and defined their Orders.
    Then, the item in the Orders list will show the link to the Order Details.

Is it possible?

Thanks for your help!
Giang Nguyen

Microsoft 365 and Office | SharePoint | For business | Windows
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Du-MSFT 51,946 Reputation points Microsoft External Staff
    2021-01-26T02:17:33.353+00:00

    @Giang Nguyen
    You could create a lookup column in the orders list to show the links to the order details list.

    1.Orders list.
    60416-1.png
    2.Order details list.
    60376-2.png
    3.Lookup column.
    60417-3.png
    4.Result.
    60433-4.png


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.