CODEWITHSUNDEEP
ms-accesslookup
user2487016
user2487016

Reputation: 51

Look Up Field in Access

I have two tables. One has information that is collected from an infopath form. The other has a list of names and employee ids. Is there a way to have a column in the first table that searches table 2 with an employee ID and looks up the name associated with that ID?

The first table has a checkin, checkout, and employee ID column. The second table has Name and employee ID.

Upvotes: 1

Views: 53

Answers (1)

HansUp
HansUp

Reputation: 97101

Since the two tables have the [employee ID] column in common, you can use a query which joins them based on that column.

SELECT
    t1.[employee ID],
    t2.Name,
    t1.checkin,
    t1.checkout
FROM
    [first table] AS t1
    INNER JOIN [second table] AS t2
    ON t1.[employee  ID] = t2.[employee ID];

Upvotes: 1

Related Questions