Linked lists - edit display

Copper Contributor

Environment: SharePoint Online

 

So this is likely one of those 'any fule knows how to do that' type questions, or one of those 'any fule knows you can't do that' type. Still, as the fule in question, guilty as charged (blush).

So let us say I have two lists, or rather, a list and a document library. The linkage allows multiple documents to be associated with a single line entry of Work_ID data:

 

DOCUMENT LIBRARY:

Document_Name

Document_Owner

Document_Contact

Work_ID - linked list field, displays Work_Lead, Work_Contact 

 

LIST:

Work_ID

Description

Work_Lead

Work_Contact

 

So far, all is well - at least for display purposes. The DOCUMENT record displays, along with related WORK_ID data. But when creating a new DOCUMENT entry, the Work_ID is a drop-down with, let's say, 200 potentially anonymous numbers in. Unless the person already knows the Work_ID to use, they would have to go away and find it. So what I'd like is for the drop down for Work_ID to also display the linked LIST:Description (and potentially other) fields in the (New Document metadata creation) screen that comes immediately after upload. Of course, as the fule indicated above and a relative novice I have no idea if this can be done and if so how :-). Might anyone have any guidance/ comment?

0 Replies