0

I have a list which contains information that is heavily linked with info in another list. The most similar example that I've seen was where someone had a list of customers and then a total list of orders. What I would be attempting to do is add a webpart to the customer list's display form to show all the customer's orders in the other list (e.g., where customer name in order's = customer name in current item).

Is this possible to do dynamically without hindering performance too much (5000 items in other list)?

Improve this question

1 Answer 1

Reset to default
2

Yes, you can do this by SharePoint Designer.

  • Add a lookup column to the Orders list, which will refer to the Customers list
  • Open Customers list in SharePoint Designer
  • Edit Customers Display Form, from the toolbar, select Insert a "Related Item View", your Orders list should show up in the option list, choose it
  • Add/Remove columns of the Orders view

You need to put the Orders list's reference column to the Customers list as Indexed column, and other columns like "Product", "Order date" etc as index columns and sort your Orders view by those indexed columns. That will make you safe with the 5,000 records throttling.

Improve this answer
7
  • edit: Actually, I don't have the option of making the fields "look up" which I believe is the key in being able to use this "Related Item View" - Is there another way of matching two field values (e.g., show me all items in the sub list where these 2 fields match 2 fields in the current item) ? Commented Apr 15, 2014 at 16:39
  • 1
    You have 2 ways to get away from the throttling: 1.Use folders; 2.Use Indexed Columns (and be sure that you have at lease one filter in your view uses an indexed column). These 2 ways will change the way a SharePoint View looking for data with reduced records to be scanned, thus can avoid the throttling. Indexed column values will not be affected, they will stay in regular format. Commented Apr 16, 2014 at 8:08
  • Another workaround without lookup fields, will be using the Query String parameter. You need somehow manage to add Customer ID into your Orders list items, then use the Query String of Customer DispForm.aspx to filter the Order List View. It's a long story and I can't find good reference from the internet. Maybe I'll write one and then post you a link here. Commented Apr 16, 2014 at 8:13
  • I actually managed to do this, but my issue is that I don't have a unique value in my Customer list. Unfortunately, my unique selector is a combination of two fields rather than one (e.g., Where Area = Area and Manager = Manager instead of ID = CustID). The "Get Filter Values From" option is only working with ID, Title, and a simple "Yes/No" column for some reason. Commented Apr 16, 2014 at 15:17
  • You can use a Calculated Column to join Area & Manager into a new column then use the new one for filtering. Commented Apr 17, 2014 at 0:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.