Vlookup equivalent/relationship

[stevembe]

Very much a newbie so do bear with me. I have built a database with two tables where both have a field labelled “Employee ID”. The second table contains Employee ID, Surname, First Name, Age, etc and what I want to achieve is auto populating table one with all this detail when the Employee ID is typed in. I am thinking of a Excel Vlookup equivalent, perhaps a relationship. Obviously not really sure so very much grateful for any advice.

 

[Joe4]

Access has a DLOOKUP function (check the help files or Google "Access DLOOKUP").

However, you can combine the two tables in a simple query, joining on the Employee ID also.

 

[HiTechCoach]

This is a cross post. See: VLOOKUP EQUIVALENT OR RELATIONSHIP

stevembe, please read Excelguru Help Site - A message to forum cross posters

 

[Joe4]

Our policy on Cross-Posting is explained here, in rule #10: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html