Keep track of where lookup items were used

Question

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)?

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?

Answer 1

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.