I have a library with client documents with client account numbers, and another list with client information that contains the account number, household number, client name, etc. Some client account numbers have multiple household numbers associated with them. In my documents library, wherever there is a document with a specific account number I'd like to pull each household number into one (or more) fields, just to have them there for reference. Would a multi-value lookup field be the best way to do this?


You can have a household information in a different list as you mentioned and add a multi-value lookup column to the client documents library. This will create one to many relationship.

  • Is there a way for me to update the multi-value lookup with all instances of the account number in the other list using a workflow or some other automated way? Eg. if that account number has 3 household numbers associated with it, it shows me all 3 household numbers. Reason being, I have thousands of documents and it would take forever to update each one manually. – user1599833 May 9 '17 at 19:31
  • Do you want to update the Client Documents library in initial setup? – Venkat Konjeti May 9 '17 at 20:11
  • Basically, yeah. Once a document is in there, it won't be changed. – user1599833 May 9 '17 at 20:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.