Can the Additional fields inside a lookup field contain another lookup field

%3CLINGO-SUB%20id%3D%22lingo-sub-1635170%22%20slang%3D%22en-US%22%3ECan%20the%20Additional%20fields%20inside%20a%20lookup%20field%20contain%20another%20lookup%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1635170%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22s-prose%20js-post-body%22%3E%3CP%3EI%20have%203%20lists%20as%20follow%3A-%3C%2FP%3E%3COL%3E%3CLI%3E%3CP%3EItemCategory%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EItem%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EInvoice%3C%2FP%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3Ethe%20Item%20list%20has%20a%20lookup%20field%20to%20the%20ItemCategory%20list%3C%2FP%3E%3CP%3Ethe%20Invoice%20list%20has%20a%20lookup%20field%20to%20the%20Item%20list.%3C%2FP%3E%3CP%3E%3CU%3E%3CSTRONG%3Enow%20i%20am%20trying%20to%20get%20the%20ItemCategory%20title%20inside%20the%20Invoice%20list%2C%3C%2FSTRONG%3E%3C%2FU%3E%20but%20seems%20this%20is%20not%20available%20inside%20the%20UI%2C%20as%20follow%2C%20where%20the%20Additional%20Fields%20section%20for%20the%20Item%20list%20does%20not%20contain%20the%20lookup%20field%20to%20the%20ItemCategory%20list%20%3A-%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22da.png%22%20style%3D%22width%3A%20561px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F216562iF531FA11D7C4E525%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22da.png%22%20alt%3D%22da.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20only%20work%20around%20i%20find%20is%20to%20add%20a%20lookup%20field%20to%20the%20Invoice%20list%20as%20well%2C%20which%20reference%20the%20ItemCategory%2C%2C%20but%20in%20this%20case%20i%20will%20have%20duplicate%20info%20for%20the%20Item%20and%20its%20Category%20(one%20inside%20the%20Item%20list%20and%20the%20other%20inside%20the%20Invoice%20list!!)..%20any%20advice%3F%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1635170%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPnP%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Valued Contributor

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

 

da.png

 

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?

1 Reply
Hi, you are right, you can't add lookup to the lookup, the way you described is applicable if you are using the out-of-box list to the end-users. If you using a custom solution, then you don't need to add the category inside the 'Invoice' list, since it can be retrieved based on the item lookup.

Hope it helps!