I have 3 lists as follow:-
ItemCategory Item 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 inside the UI, as follow, where the Additional Fields section for the Item list does not contain the lookup field to the ItemCategory list :-
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?