I have 3 lists as follow:-
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:-
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?