Build related tables with the Access 2007 Lookup Wizard

(Mary Ann Richardson) You’ve just created an Employee Records table for your Employees database that lists personal information (such as Address, Phone Number, and Birth date) for each employee. Now you need to create a second table that lists each employee’s work location and job title. This new table will use the Employee ID field in the Employee Records table as its foreign key field, a field that refers to the primary key field in another table.