0

I have 3 lists as follow:-

  1. ItemCategory

  2. Item

  3. Invoice

the Item list has a lookup field to the ItemCategory list

the Invoice list has a lookup field to the Item list.

now i am trying to get the ItemCategory title inside the Invoice list, but seems this is not available, as follow:-

enter image description here

the only work around i find is to add a lookup field to the Invoice list as well, which reference the ItemCategory,, but in this case i will have duplicate info for the Item and its Category (one inside the Item list and the other inside the Invoice list!!).. any advice?

2
  • 1
    I would merge ItemCategory and Item into one list, that's, add a Category column in Item list. Sep 3, 2020 at 19:56
  • @MatiurRahman ok let say i did so,, then how i can get the ItemCategory inside the Invoice list (which is my main question), where as shown in the screen shot i provided the lookup column inside the Item list (lookup to the ItemCategory list) can not be selected (similar to the Title, Id, Created,version,etc..) when creating the lookup between the Invoice and the Item lists... did you get my point?
    – John John
    Sep 4, 2020 at 10:13

2 Answers 2

1

Lookup column does not have a transfer inheritance relationship. You could merge ItemCategory list and Item list.

4
  • ok let say i did so,, then how i can get the ItemCategory inside the Invoice list under the additional fields (which is my main question), where as shown in the screen shot i provided the lookup column inside the Item list (lookup to the ItemCategory list) can not be selected (similar to the Title, Id, Created,version,etc..) when creating the lookup between the Invoice and the Item lists... did you get my point?
    – John John
    Sep 4, 2020 at 10:13
  • 1
    Lookup column cannot be selected in the additional fields by default. Sep 7, 2020 at 9:50
  • @ Emily Du - MSFT thanks ,, but can you advice more on what you mean by "By default"?can i have any workarounds?
    – John John
    Sep 7, 2020 at 9:51
  • You could create a single line of text column in the Item list. Text column have the same value as lookup column. Then use text column in the additional fields. Sep 9, 2020 at 10:36
0

Items list showing ItemTitle and ItemCategory

enter image description here

Create a Lookup Column (ItemOrdered) in Invoice list pointing to Items list showing ItemTitle and ItemCategory in Invoice list

enter image description here

Invoice List Showing ItemTitle and ItemCategory

enter image description here

3
  • but in my case the ItemCategory need to be a lookup field and not a single line of text field..this is my main issue..
    – John John
    Sep 4, 2020 at 13:12
  • As you already know, SP can't model data as SQL Server does. Is there a reason that "Category" needs to be a look up column in Item list? Sep 4, 2020 at 13:34
  • yes so if i delete an itemcategory then all the items will be removed, also if i updated the itemcatgory title it will get reflected inside all the items' categories, also i am using the ItemCategory on other lists, and so on..
    – John John
    Sep 4, 2020 at 14:11

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.