Have to build query that joins the two tables in order to retrieve all related info. That is why I suggested the form RecordSource to include both tables. Keep in mind, including the lookup table is only to view that info, not edit.