There is more than one way to do that. One very important difference is whether you copy that data into your current record or link to the data in a related record. Both methods can be the best option depending on the needs of your database.
Both options start by defining a relationship that matches records by DL. See this thread for a description of how to set up both options: Auto Fill
Thanks for the comment. The issue I run into is can this be done with only one table. I need to have the information copied onto each record.
I think you need to explain that answer in more detail.
The issue I run into is can this be done with only one table
The example in that thread does not use only one table, but they could if that were necessary.
I need to have the information copied onto each record.
Both methods described in that thread will do exactly that.