I have a custom list A that has a lookup field for items in a custom list B, is there a way to know where a list B item was used in the list A?


I'll try to give an example, say A is a list of stores and B is a list of products. I have a lookup column on list A that references the products on list B (which products does this store sell) and my question is: If i have a product (item from B), can i know which stores sell it (which items in A reference in their lookup column the item from B)?

List A lookup column referencing B list items

A has the lookup column and item 1 and 4 reference item 2 from list B, if just given 2 from B, can i know which items from A are referencing B?

B knows what references him?


To know which items from A are referencing B?

  • Create a custom view at Store List (A).
    • List Settings > at Below of page > Click create a View.
  • Set its name.
  • Select the column that you need to show.
  • At Group by section select the Lookup field from Products (B)
  • Also, at Totals select it to show count beside each product.

This should list all items at store list (A) grouped by all Products at (B) with its count.

  • I did as you said but the lookup field doesn't show up at the "Group by" or "Totals" sections (all the others do). – agp Aug 22 '16 at 10:00
  • this lookup field is multiple or signal selection , please share your lookup field settings – Mohamed El-Qassas MVP Aug 22 '16 at 10:05
  • is multiple selection – agp Aug 22 '16 at 10:07
  • it only shows without multiple selections , and at your above image, you make relation one to many from B to A so why you need it multiple ? Please tell me if you need more clarification – Mohamed El-Qassas MVP Aug 22 '16 at 10:09
  • Because, staying at the example logic, a store can sell more than one product, i.e. A item can have more than one B items associated (puu.sh/qK7jb/fdf77dad0f.png my lookup field settings) – agp Aug 22 '16 at 10:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.