1

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?

edit:

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?

Improve this question
2
  • Can you please elaborate your question with example or can you rephrase the question for better understanding. Commented Aug 22, 2016 at 8:39
  • Is this is what you want? pawansatope.blogspot.in/2012/01/… Commented Aug 22, 2016 at 8:42

1 Answer 1

Reset to default
2

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.

Improve this answer
6
  • I did as you said but the lookup field doesn't show up at the "Group by" or "Totals" sections (all the others do). Commented Aug 22, 2016 at 10:00
  • this lookup field is multiple or signal selection , please share your lookup field settings Commented Aug 22, 2016 at 10:05
  • is multiple selection Commented Aug 22, 2016 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 Commented Aug 22, 2016 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) Commented Aug 22, 2016 at 10:12

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.