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.