I'm looking to create a list for a client in SharePoint. What I'm trying to achieve is that when a new object is created I want a pre-defined list of clients to auto-populate a new list based on the initial selection.
A service technician picks a client for a job, say Akademikliniken HJ AB. This client has several locations that need to be defined in order to submit the proper data. So my question is this, how do I create a pre-defined list where company name only shows up once and -upon selection- auto-populates a new list the various locations for that client?
I hope that I'm clear. I really appreciate your help with this. Please see below for an snippet of the list I'm pulling data from.