Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

So, the question does a poor job of outlining the problem. Apologies.

I've got one list where my clients track their projects; let's call it Projects. In it, they make a selection on a multiple choice column indicating what area of the company their project affects. The purpose of this is so that when it's time for the project to receive approval, it can be routed to the appropriate approver.

Approvers are linked with the respective areas via another list, which we'll call AreaOwners.

Occasionally, clients will have projects that affect multiple areas. Multiple areas require multiple approvers. So, how do I grab multiple names from my AreaOwners list based on multiple selections from the area column. It'd look like this:

Projects

ID Area

1 NOC, LOC

AreaOwners

Area OwnerName

NOC Jane Doe

LOC John Doe

POC Jack Johns

...

If I need to provide more information, I can.

Thanks in advance.

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.