SharePoint has the ability to act as a basic relational database. Thus, you can create one list that if referred to by other lists. This means that you can maintain only a single location for all your information. The most basic method to achieve this is by using Lookup Columns.
This tutorial will show you how to create a lookup column in a new list and then how to work with the information. You’ll see how to add and update information as well as edit the column headings in the new list so they present better.
This video is another in my Intermediate SharePoint series that you can follow through. Of course don’t forget my Getting Started with SharePoint series which you also get via email or download and install on your own SharePoint Team Site. You can subscribe to the free Getting Started with SharePoint lessons by entering your email below.