Creating LOOKUPS in MS Access

In this tutorial we will create a lookup from the transaction table back to the entity tables to reduce user data entry errors. This tutorial follows on from duel primary keys.

[deepsharmaindia]

Hi Leon. How can we reference data from enrolments table in another table, let's say fee details?
I need column like student name and course from enrolment table to be looked up in fee details table. I tried lookups, but it just shows the IDs, not names!!!