I have a Sharepoint List called Volumes to which I plan to add a column called providers. I have a second Sharepoint list called ProviderList. I would like for my end user to use to populate the providers column in the Volumes list with (presumably a dropdown) choices from ProviderList. How can I do this? If it isn't clear from the nature of my question, I know next to nothing about SharePoint, but find myself needing to support it. I am an SQL developer. Thanks.
In Volumes list you can add a new column named Providers.
Then choose the type as look up from another list. Choose Provider List.
Update - Many columns in other lists may not show in lookup list. Some common columns such as ‘id’, ‘version’ etc. can be shown in most cases. When you create a new lookup column and pick a list from the "Get Information from:" option you will only see Single Line of Text columns display in the drop down list.