Basing a Form on a Multiple-Table Query
When you bring together data from multiple tables using select queries, the result of that query is called a recordset. A recordset contains all the information you need, but it’s in the unadorned Datasheet view format. Forms enable you to present this data in a more attractive and meaningful way. And in the same way that you can update data with queries, you can also update data using a form that is based on a query.
Creating a Many-to-One Form
It’s easy to design a form that allows you to view and update the data from a single table. Although you can include selected fields from related tables using a list box or a combo box, what if you want to see more information from the related tables? The best way ...
Get Microsoft Office® Access 2007 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
