I am new to SharePoint so please bear with me. My environment is Sharepoint 2103 standard (Planning upgrade to Enterprise soon) on premise with separate SQL server 2014 installation.
I've built several "lookup lists" as I'll call them, that contain pieces of information I will use throughout my sites. (example Employees) I've built another list (vehicles) with other pieces of information pertaining to vehicles but a "lookup" of the employee name. Works great!
I have a document library where I want to store maintenance documents for each vehicle and when I attempt to get the employee (which is a lookup field in the vehicle list) - no deal. I can do another lookup of employees but then I have to select from all existing employees. I'm thinking SharePoint should know that I already assigned an employee to that vehicle and just deliver.
What am I missing? Can I accomplish this? Should I be using Managed Metadata instead of "lookup" lists?
Thanks in advance for your assistance and comments. Gene