Vlookup equivalent in Access?

Hi all,

I am currently working on an Access project.

I have 2 tables:
Table 1 has 10 fields: Account ID, Employee ID, etc
Table 2 has 3 fields: Account ID, Employee ID, Commission Date

Both tables have the same Account ID and Employee ID information.

What I want to do is I want to pull Commission Date information from Table 2 and put it on Table 1. The data on Commission Date will vary depending on Account ID and Employee ID.

If this is in Excel, I can always use vlookup. But I am currently on Access and I have never used Access before.

I would also need to do this every month so I think I would need to use a type of programming language (like a macro) that would automate this.

Since I am VERY new on Access and even more on programming language, I would appreciate it if you guys could provide me with a detailed step by step guidance

Thanks for your help!

Cross post /double post
http://www.accessforums.net/access/need-help-defining-relationship-27686.html

Please do NOT cross post without advising the reader.

Please don't cross-post without providing links to your cross-posts. We answer questions for free. Please don't waste the time of the people helping you.
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

Not only cross-posting but double-posting too.

http://www.access-programmers.co.uk/forums/showthread.php?t=232399

Not good ewong.