Using Table to lookup and match to another Table

[michaelak117]

I import about 9000 lines of data into Access and that consists of many lines of initials. One persons initial could include hundreds of rows and then the initial changes to another person. I would like to lookup to another table that has the persons full name. Such as many rows of AFu apprearing as Amy Funk in another field. How would I make this happen with this much data. I know how to create a lookup and choose from the drop down box but obviously this is ineffective with 9000 rows of data. I simply want this lookup so I can create a query using the full names. Can anyone tell me the solution. Thanks

Mike

 

[boblarson]

Just link the two tables on that initials field within the query (yes, you can have more than one table in a query). Then just drag the name into the query fields from the table alongside the other fields from the other table.