Access Tip - Multi-table forms and reports
To create a form or report that uses data from multiple tables, base your form or report on a query.