Page 1 of 1

Lookup with one source list

Posted: 02 Jun 2021
by TWendt
Hi all,

I have one source list with the columns Customer, Serial no. and System type. Now I create a destination list where I will make a lookup to the columns from the source list. For example, I select in the first column of the destination list Customer and in the next column then I would like select the Serial no. from the same source list. Because a customer can have multiple serial no. Is it possible. If yes can you give me an example?

Best wishes
Tom

Re: Lookup with one source list

Posted: 02 Jun 2021
by Nikita Kurguzov
Dear Tom,
This sounds like a standard Cascading lookup setup, especially if Customer is a lookup to another list, where the customers are stored. You can find how to setup cascading lookups here - https://spform.com/cross-site-lookup/ca ... office-365