I have a custom list where a user enters information about a vehicle. I want to validate what the user enters as Vehicle ID, against a master Vehicle ID list contained in a seperate custom list.

Is this possible using a validation formula?

  • 1
    This is not possible OOTB. But you could create the lookup column, so user could have the combo box of all vehicle ids to choose from. – Damjan Tomic Jan 10 at 17:58
  • Why do you want to validate from a separate list? Can you give a better explanation of the business requirement? – KGlasier Jan 10 at 18:05

Damjan has the right answer: create a lookup column. If there are a huge number of vehicle IDs, making a lookup list cumbersome to use, perhaps check out a managed metadata field (which uses its own data store, not a separate list), or get a developer involved to write an event handler.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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